IDWBI
IDWBI
  • Видео 58
  • Просмотров 419 149

Видео

How does Metadata help with the Business Processes and Procedures?
Просмотров 159Год назад
How does Metadata help with the Business Processes and Procedures?
What are the common Questions specific to an attribute in a real time project?
Просмотров 62Год назад
What are the common Questions specific to an attribute in a real time project?
What questions does Metadata Management helps us to answer?
Просмотров 76Год назад
This lecture talks about the different common questions Metadata Management can answer.
Why do we need to manage Metadata?
Просмотров 94Год назад
Metadata is created and collected because it enables and improves use of that data. Metadata ensures that we will be able find data, use data, and preserve and re-use data in the future.
Common Metadata Examples from our day to day work/activities
Просмотров 112Год назад
Here are some of the Metadata examples which we see on a daily basis
What is Metadata?
Просмотров 240Год назад
Metadata is simply data about data. It means it is a description and context of the data. It helps to organize, find and understand data. Metadata is information about the data collected. According to the Data Management Body of Knowledge (DMBOK), metadata “includes information about technical and business processes, data rules and constraints, and logical and physical data structures.”
How many servers are present in X Large Warehouse?
Просмотров 2 тыс.Год назад
16 servers are present in X-Large Warehouse. Warehouses are required for queries, as well as all DML operations, including loading data into tables. A warehouse is defined by its size, as well as the other properties that can be set to help control and automate warehouse activity. Warehouses can be started and stopped at any time. They can also be resized at any time, even while running, to acc...
What is the default type of table created in Snowflake?
Просмотров 1,9 тыс.Год назад
The default type for tables is permanent. To define a table as temporary or transient, you must explicitly specify the type during table creation.
Difference and Similarities between Transietnt and Temporary Tables in Snowflake
Просмотров 2,4 тыс.Год назад
Difference and Similarities between Transietnt and Temporary Tables in Snowflake
Can we create Transient Views in Snowflake?
Просмотров 2,3 тыс.Год назад
In Snowflake, we can create the below views. Standard View Secure View Materialized View Transient View is an Invalid view type. We can create transient tables in Snowflake but not transient views. Transient Tables:- Snowflake supports creating transient tables that persist until explicitly dropped and are available to all users with the appropriate privileges. Transient tables are similar to p...
Micro partitions in Snowflake
Просмотров 4,5 тыс.Год назад
All data in Snowflake tables is automatically divided into micro-partitions with each partition containing between 50 MB and 500 MB of uncompressed data. Each micro-partition maps to a group of rows and is organized in a columnar fashion. This size and structure allows for both optimization and efficiency in query processing. Micro-partitions allow users to perform extremely efficient DML and f...
Time travel in Snowflake
Просмотров 3 тыс.Год назад
Enterprise Edition, Business Critical Edition and VPS Edition have the option to enable time travel for up to 90 days.
Is Snowflake an MPP database?
Просмотров 4,4 тыс.Год назад
MPP stands for Massively Parallel Processing, and is a database architecture successfully deployed by Teradata and Netezza. Unlike traditional Symmetric Multi-Processing (SMP) hardware which runs a number of CPUs in a single machine, the MPP architecture deploys a cluster of independently running machines, with data distributed across the system. In addition to the ability to handle massive dat...
Table types in Snowflake
Просмотров 5 тыс.2 года назад
There are four types of tables which can be created in Snowflake 1. Permanent:- It is the regular database table. Consumes space, Time-travel and fail-safe period can be enabled. All tables in snowflake by default are micro-partitioned, compressed, encrypted, and stored in columnar format. Permanent tables are designed for data that requires the highest level of data protection and recovery. Th...
Snowflake Architecture
Просмотров 17 тыс.2 года назад
Snowflake Architecture
Difference between MRS & DIS, PCRS & PCIS
Просмотров 1,1 тыс.3 года назад
Difference between MRS & DIS, PCRS & PCIS
Unable to Login to Informatica Power Center Adminstration Console
Просмотров 7 тыс.3 года назад
Unable to Login to Informatica Power Center Adminstration Console
Converting Columns to Rows in Informatica Power Center
Просмотров 13 тыс.3 года назад
Converting Columns to Rows in Informatica Power Center
How to identify Null records and move it to a target or error table
Просмотров 6 тыс.3 года назад
How to identify Null records and move it to a target or error table
Alternative Target Load or Even Odd numbers load
Просмотров 1,3 тыс.3 года назад
Alternative Target Load or Even Odd numbers load
How to identify the Duplicates in Informatica using Expression Transformation
Просмотров 9 тыс.3 года назад
How to identify the Duplicates in Informatica using Expression Transformation
How to identify the Duplicate records in Informatica Power Center?
Просмотров 3,6 тыс.3 года назад
How to identify the Duplicate records in Informatica Power Center?
Different terms used as part of the mapping in Informatica Cloud.
Просмотров 1,4 тыс.3 года назад
Different terms used as part of the mapping in Informatica Cloud.
Informatica Cloud Connectivity and Secure Agent
Просмотров 6 тыс.3 года назад
Informatica Cloud Connectivity and Secure Agent
Informatica Cloud Architecture overview
Просмотров 8 тыс.3 года назад
Informatica Cloud Architecture overview
Different Components of Informatica Cloud - IICS
Просмотров 1,5 тыс.3 года назад
Different Components of Informatica Cloud - IICS
Power Center On Cloud Vs Informatica Cloud
Просмотров 2,9 тыс.3 года назад
Power Center On Cloud Vs Informatica Cloud
Power Center On premise Vs Informatica Cloud
Просмотров 12 тыс.3 года назад
Power Center On premise Vs Informatica Cloud
Informatica 10.2 Client Installation on Windows
Просмотров 4473 года назад
Informatica 10.2 Client Installation on Windows

Комментарии

  • @MackintoshWright
    @MackintoshWright Месяц назад

    540 Hintz Manors

  • @ismailcbewin
    @ismailcbewin Месяц назад

    All table can add Time travel option?

  • @shaikhabubakarshaikhhabeeb8554
    @shaikhabubakarshaikhhabeeb8554 3 месяца назад

    make videos on mock interview instead of this.

  • @rmcken13
    @rmcken13 3 месяца назад

    I dont think it works like this in CDI :(

  • @alexanderheath8973
    @alexanderheath8973 4 месяца назад

    Immediately understand what is going on. Great explanation. Cheers fella

  • @rajrajabhathor2996
    @rajrajabhathor2996 5 месяцев назад

    Totally agree ! Very clear and simple explanations ! - all of this Gentleman's Video series...

  • @firstsecond1798
    @firstsecond1798 6 месяцев назад

    Hi Sir... Will you mind teaching students online for my academy. We can discuss on commercials

  • @dilli1924
    @dilli1924 8 месяцев назад

    Currently we have redhat linux7.9 version installed with informatica 10.2 version . Can anyone tell Which latest version of redhat linux supports Infa 10.2 version if we want to upgrade from 7.9 to 8 or 9 version ?

  • @rajendrawarrier7274
    @rajendrawarrier7274 10 месяцев назад

    reliability is whether the underlying data can be trusted or not?!

  • @THegenathorChannel
    @THegenathorChannel 10 месяцев назад

    :)

  • @NarasimhaMurthy-x1b
    @NarasimhaMurthy-x1b 11 месяцев назад

    Very well explained! Thanks

  • @Cazz_life
    @Cazz_life Год назад

    Great playlist

  • @werner6816
    @werner6816 Год назад

    nice video, but I'm still having so many basic questions like: how does the warehouses look internally like / how does the query optimizer work / how is metadata handled / how does caching work in detail / how does the warehouse make sure that latency and performance on storage operations is okay / how does the communication protocols inside of warehouse and to storage layer look like / etc.

  • @prasadyuvi5990
    @prasadyuvi5990 Год назад

    Exllent Explanation

  • @Craft_bee_24
    @Craft_bee_24 Год назад

    Thank you.. Its working sir

  • @harshikasingamsetty5019
    @harshikasingamsetty5019 Год назад

    Hii bro why records not getting written in informatica from the source

  • @santoshh_5
    @santoshh_5 Год назад

    Thank you God bless you 😁🙏

  • @smirthi3693
    @smirthi3693 Год назад

    Among 2 expressions, what is the purpose of 1st expression transformation?

  • @ananthalakshmirednam7315
    @ananthalakshmirednam7315 Год назад

    Good explaination

  • @prakasharc7629
    @prakasharc7629 Год назад

    I am getting below error. How to fix this? Service restarted. com.informatica.repository.svcfw.SvcLogService log SEVERE: [localhost-startStop-1] Failed to start the Repository Service ['ISP-Repository'] for the following reason: ['[PRSVCSHARED_01601] The following packages are either not registered with the Repository Service or are of a lower version:

  • @satyamchallari3978
    @satyamchallari3978 Год назад

    Thank you for detailed video , would like to have your email ID on training

  • @danielejiofor3493
    @danielejiofor3493 Год назад

    Best Explanation I have seen!!!!

  • @PraveenKumar-il8kn
    @PraveenKumar-il8kn Год назад

    Hi Sir, Is any trainings are providing for ETL testing?

  • @salmasowkath1128
    @salmasowkath1128 Год назад

    Was struggling a lot to sort out the issue...Thank you so much Sir

  • @pavanireddy4479
    @pavanireddy4479 2 года назад

    How can i run the tool after installation, anyone can please reply

    • @TheIDWBI
      @TheIDWBI 2 года назад

      Start the Oracle and Informatica Services and start accessing the PowerCenter Tools

  • @mahanteshhiremath3168
    @mahanteshhiremath3168 2 года назад

    is there any easiest way to move onpremise informatica (wf, mappings ) to could.?

    • @TheIDWBI
      @TheIDWBI 2 года назад

      You can use the XML export and import options. But make sure to test the imports

  • @deepikasisode
    @deepikasisode 2 года назад

    Pls more videos

    • @TheIDWBI
      @TheIDWBI 2 года назад

      More videos are coming

  • @bonigelavaishnavi654
    @bonigelavaishnavi654 2 года назад

    Hi, I am using oracle db and installed informatica 10.20 version on my VMware which has been installed in Ubuntu 20. 04 version. Unable to open admin console file and opened catalina. Out(memory leakge error) and exception log file(error:Cannot update the data for master gateway. The domain configuration repository db may not be available. Verify that the db is available) . Kindly let me know what can i do now.

    • @TheIDWBI
      @TheIDWBI 2 года назад

      What is the RAM available on your PC? Please close all the unnecessary applications and try to start the services again

  • @souravghosh8274
    @souravghosh8274 2 года назад

    you have mentioned that for on premise sytems secure agent comes into picture. so for could systems we dont need secure agent. am i right?

    • @TheIDWBI
      @TheIDWBI 2 года назад

      For most of the cloud options, it is based on how the other cloud provider has given the options to integrate. If there are REST APIs in picture or direct connection via OAUTH methods etc then you would not need the secure agents. We just have to take care of the firewall/network issues and things should work

  • @kommanajyothsna7646
    @kommanajyothsna7646 2 года назад

    How does Informatica works on non shared filesystem

    • @TheIDWBI
      @TheIDWBI 2 года назад

      Permissions. If the file system can be accessed by the Informatica user it works.

  • @galiramanaji7625
    @galiramanaji7625 2 года назад

    Err_connection_network issue coming

  • @rajpandim
    @rajpandim 2 года назад

    Excellent

    • @TheIDWBI
      @TheIDWBI 2 года назад

      Thank you! Cheers!

  • @kumariankita9267
    @kumariankita9267 2 года назад

    I tried this but its not working for me. Seems like it does not follow order in variables

  • @gerardolopez5593
    @gerardolopez5593 2 года назад

    Do you know how complex would be to migrate from On Premise to Cloud? THanks

  • @sureshrangadhamaiah7704
    @sureshrangadhamaiah7704 2 года назад

    This was so cool!!!

  • @slyroy7562
    @slyroy7562 2 года назад

    Hi Sir, One Doubt :- I'm having one csv file which is in informatica source path (unix path)(Source analyzer--> import from flat file) Here while clicking in import from flat file it's showing my local desktop path. How I can connect to unix path (I have given source path(unix path) in session properties source directory/path it's working fine). But when im importing from my local windows path Delimiter validation and string length I have given at my end. But when it's move to production their we cant manually import source and dont change any Delimiter and string length. How we can change string length and Delimiter in production

  • @nehalgada8926
    @nehalgada8926 2 года назад

    Thanks @IDWBI . Can you please post video for 10.5 informatica server installation too

  • @nikhitaaneesha3901
    @nikhitaaneesha3901 2 года назад

    ok

  • @elurivenu8881
    @elurivenu8881 2 года назад

    good explanation

  • @akshatabedarkar8472
    @akshatabedarkar8472 2 года назад

    I am unable to find catalina.out and exception.log ...can anyone help me ..I am facing the same issue

  • @harishukkisala280
    @harishukkisala280 2 года назад

    My repository service is not working pls support sir

  • @kunalhansraj4151
    @kunalhansraj4151 3 года назад

    Cant we do this using 3 expressions with 3 columns in each and then map it tp target, rather than using uniom or dping calculations. I have tested this works fine

  • @sharonhockenberry
    @sharonhockenberry 3 года назад

    Great job!

  • @electrovasa3549
    @electrovasa3549 3 года назад

    Thanks for the detailed explanation!

  • @matthias2912
    @matthias2912 3 года назад

    We will see, if the cloud-solution can be as competitive as PowerCenter in perspective of complexity and performance. I doubt that still, as I know the performance of the Developer and Model-Repo.

  • @teja2775
    @teja2775 3 года назад

    useless video

  • @harivgl
    @harivgl 3 года назад

    What are the differences between these 3: AWS Glue, AWS Data Pipeline, Informatica. What are the advantages/disadvantages of using each ? Also confused with Informatica as it has an Informatica Powercenter and Informatica Intelligent Cloud Services (IICS). Within AWS why does Glue and Data Pipeline exist as seperate services ? How will anyone choose between informatica and either of the AWS services ?

  • @youngboyneverharamagain3593
    @youngboyneverharamagain3593 3 года назад

    Yoda?

  • @indum540
    @indum540 3 года назад

    In second instance /example .it is columns to rows right ..?

  • @indum540
    @indum540 3 года назад

    Clear Explanations