- Видео 58
- Просмотров 419 149
IDWBI
Швейцария
Добавлен 15 авг 2013
This channel will post the videos related to Snowflake, Informatica Power Center, IICS, Informatica Data Quality, Informatica B2B, LINUX, SQL, ETL Testing, Data Warehouse Concepts, Soft Skills, LINUX and other BI tools.
How does Metadata help with the Regulations and compliance like GDPR and CCPA/CPRA?
How does Metadata help with the Regulations and compliance like GDPR and CCPA/CPRA?
Просмотров: 282
Видео
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...
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
540 Hintz Manors
All table can add Time travel option?
make videos on mock interview instead of this.
I dont think it works like this in CDI :(
Immediately understand what is going on. Great explanation. Cheers fella
Totally agree ! Very clear and simple explanations ! - all of this Gentleman's Video series...
Hi Sir... Will you mind teaching students online for my academy. We can discuss on commercials
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 ?
reliability is whether the underlying data can be trusted or not?!
:)
Very well explained! Thanks
Great playlist
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.
Exllent Explanation
Thank you.. Its working sir
Hii bro why records not getting written in informatica from the source
Thank you God bless you 😁🙏
Among 2 expressions, what is the purpose of 1st expression transformation?
Good explaination
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:
Thank you for detailed video , would like to have your email ID on training
Best Explanation I have seen!!!!
Hi Sir, Is any trainings are providing for ETL testing?
Was struggling a lot to sort out the issue...Thank you so much Sir
How can i run the tool after installation, anyone can please reply
Start the Oracle and Informatica Services and start accessing the PowerCenter Tools
is there any easiest way to move onpremise informatica (wf, mappings ) to could.?
You can use the XML export and import options. But make sure to test the imports
Pls more videos
More videos are coming
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.
What is the RAM available on your PC? Please close all the unnecessary applications and try to start the services again
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?
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
How does Informatica works on non shared filesystem
Permissions. If the file system can be accessed by the Informatica user it works.
Err_connection_network issue coming
Excellent
Thank you! Cheers!
I tried this but its not working for me. Seems like it does not follow order in variables
Do you know how complex would be to migrate from On Premise to Cloud? THanks
This was so cool!!!
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
Thanks @IDWBI . Can you please post video for 10.5 informatica server installation too
ok
good explanation
I am unable to find catalina.out and exception.log ...can anyone help me ..I am facing the same issue
My repository service is not working pls support sir
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
Great job!
Thanks for the detailed explanation!
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.
useless video
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 ?
Yoda?
In second instance /example .it is columns to rows right ..?
Clear Explanations