- Видео 100
- Просмотров 151 414
Suresh ETL Trainer
Индия
Добавлен 2 окт 2022
Learn ETL tools like Informatica Power Center, Snowflake,Informatica Cloud (IICS), Informatica Data Quality (IDQ) On Demand Technologies as per your availability.
Complex Mapping in Information in Detail Explanation
Complex Mapping in Information in Detail Explanation
Просмотров: 253
Видео
Update Strategy Transformation with SCD1 in Informatica
Просмотров 134Месяц назад
Update Strategy Transformation with SCD1 in Informatica
ETL Unit Testing Template with Example (With Audio)
Просмотров 3783 месяца назад
ETL Unit Testing Template with Example (With Audio)
ETL Unit Testing Template with Example
Просмотров 2024 месяца назад
ETL Unit Testing Template with Example
Worklets in informatica with example
Просмотров 5525 месяцев назад
Worklets in informatica with example
What are different types of partitioning in Informatica
Просмотров 1,8 тыс.6 месяцев назад
What are different types of partitioning in Informatica
Difference between Informatica PC and IICS
Просмотров 6796 месяцев назад
Difference between Informatica PC and IICS
Informatica Interview Questions-Sequence Generator NextVal & CurVal
Просмотров 5756 месяцев назад
Informatica Interview Questions-Sequence Generator NextVal & CurVal
How to improve Performance of informatica Workflow
Просмотров 8226 месяцев назад
How to improve Performance of informatica Workflow
Frequently asked SQL queries for interview || Top SQL Queries
Просмотров 1,4 тыс.7 месяцев назад
Frequently asked SQL queries for interview || Top SQL Queries
Informatica Calls Started || Points to remember to clear the Interview's
Просмотров 1 тыс.7 месяцев назад
Informatica Calls Started || Points to remember to clear the Interview's
Different Ways to set Dependency between Workflows in Informatica
Просмотров 3487 месяцев назад
Different Ways to set Dependency between Workflows in Informatica
Dynamic File Generation in informatica
Просмотров 5568 месяцев назад
Dynamic File Generation in informatica
Unix Commands Used in Informatica Power Center Part-2
Просмотров 7588 месяцев назад
Unix Commands Used in Informatica Power Center Part-2
Unix Commands Used in Informatica Power Center Part-1
Просмотров 9808 месяцев назад
Unix Commands Used in Informatica Power Center Part-1
Difference Between Versioned & Non-Versioned Repository in Informatica
Просмотров 2418 месяцев назад
Difference Between Versioned & Non-Versioned Repository in Informatica
Difference Between Versioned & Non-Versioned Repository in Informatica
Просмотров 1888 месяцев назад
Difference Between Versioned & Non-Versioned Repository in Informatica
Different ways to perform Migration / Deployment of Informatica Code
Просмотров 1,6 тыс.8 месяцев назад
Different ways to perform Migration / Deployment of Informatica Code
Key points to remember before design your ETL Mapping
Просмотров 8379 месяцев назад
Key points to remember before design your ETL Mapping
Why Look up Transformation is active || Lookup Policy on Multiple Match
Просмотров 4729 месяцев назад
Why Look up Transformation is active || Lookup Policy on Multiple Match
List File Approach in Informatica with Example
Просмотров 4379 месяцев назад
List File Approach in Informatica with Example
Naming Conventions in Informatica(ETL)
Просмотров 4099 месяцев назад
Naming Conventions in Informatica(ETL)
Informatica Interview Questions Part -13
Просмотров 5669 месяцев назад
Informatica Interview Questions Part -13
Test Case Document || Test Case Creation In Informatica
Просмотров 62210 месяцев назад
Test Case Document || Test Case Creation In Informatica
Standardizer Transformation In Informatica Data Quality (IDQ)
Просмотров 31510 месяцев назад
Standardizer Transformation In Informatica Data Quality (IDQ)
What are the things you should do/don't after joining to Project
Просмотров 33810 месяцев назад
What are the things you should do/don't after joining to Project
Explain Common ETL(Informatica) Bugs/Defects faced in your Project
Просмотров 76910 месяцев назад
Explain Common ETL(Informatica) Bugs/Defects faced in your Project
Error Table Concept in Informatica Detail Explanation
Просмотров 35710 месяцев назад
Error Table Concept in Informatica Detail Explanation
ETL Project Flow Explanation in Simple Terms
Просмотров 65410 месяцев назад
ETL Project Flow Explanation in Simple Terms
very nicely explained sir, thank you so much
Thank you Keep watching
Hi Sir, I am following you from a long ago, your a very good teacher who are going to learn informatica.. I have learn a lot from your videos on Power center.. I can easily understand and your way of explanation also is very intresting. but this video has a lot of disturbance and video quality also not good sir. can u please take care of this little bit issues it would be helpful for us. thank you sir for giving good knowledge for us..
Sure .. Thank you let me check
Your audio is not clear
Let me check
56122 Lynch Tunnel
HI Suresh in interview they have asked how you load the fact and dimension tables?can you please explain?
Will do one video
@@sureshetltrainer Thank you Suresh
Thank you Very much ...and I have request pls do one video for to face client interview on informatica
Sure I will
Thank you so much Suresh I have attended many interviews in every interview they have asked I was unable to answer now I can understand.
keep watching and share with your friends
992 Gerlach Freeway
Thank you for this
Keep watching for more videos
Sir i have completed my informatica powercenter etl developer course,i would like to learn iics also ,please help me to choose cdi,cai,idmc,di,which one i need to learn sir.
IICS with CDI & CAI is good
How is it different from Lookup? We can do the same thing in Lookup as well
Can we just get the count of records in source qualifier alone without any fields?
No
9300 Boyer Union
Please create a Playlist for snowflake from start to end
Sure
Informatica tool ends in next 2 years ?
It never...it may be old ..but all new ETL tools based on informatica only...
Sir datastage is good ??
Yes datastage is also good but limited calls
How to do connection informatica to Kafka for streaming data can you make video on it.
Can you tell me difference b/w Data Quality vs Data profile ?
Sir informatica developer,job supporting is any possibile sir
You said that dynamic cache concept is used if we encounter multiple records on one id, but my question is we can delete duplicate records in many ways. why should we use this dynamic cache concept? and one more question is in dynamic lookup, we are already comparing values with the associated port, then why we are giving in condition tab again?
The first reason for using dynamic lookup to improve the performance of the job, if you use other ways to remove duplicates the performance will degrade. With condition only the lookup will work.
Can you explain XML transformation with the help of mapping sir? and also Parameterization.
Sure
Hi Sir, is it right to say that Source Qualifier is somewhat similar to Catalyst Optimizer(Spark Sql Engine) used in Spark? Main difference being optimization and techniques are outdated and for handling only GBs of data when it comes to Source Qualifier of Informatica.
How to check missing records in target in informatica Powercentre
Thanks for watching please share with your friends
can i move to Etl Datastage to informatica could u pls gell me 😢😢 got a no call from Datastage ...can i get more call s from informativa pls tell me what dif between datastahe vs informatica pls rell me helllo
Both are ETL tools only... please give me call for more information 9060099974
Thanks for the great video
Thank you... keep watching
Thank you so much for the great video
Glad you enjoyed it!
every day we are trying to load the data into target the code is not into production still it in testing phase 1st day the vendor sends 10 columns with the header and coma separated and we load that file to target and next day the vendor sends 5 columns and 4 columns like this every day in the file but vendor is not changing any columns or add new columns and the vendor jumbling position of the columns and vendor is not pass null for missing columns this is the structure of the file need to load data without losing any record how will we load the data to target in informatica power center and IICS Kindly explain this scenario please...
Sir make video on etl retail project end to end testing r
Will try
Hi Sir . How to find workflow running last 6 months .Can you please help me on this
You can configure in working flow monitor
Sir if possible can you please explain this please.actually I am stucked.
Scenario : dynamic file structure I have to load the flat file using informatica power center whose structure is not static. Number of columns will get changed in the future run. Here is the source file: ex : first day file emp_id , e_name, e_city 1 xys wer 2 sdf sdf second day file emp_id , e_name, e_city ,e_zipcode , 1 xys wer 34543 2 sdf sdf 35345 In the sample file I have 3 columns right now but in the future I can get only 4 columns or I may get another set of new columns as well. I can't go and change the code every time in the production , I have to use the same code by handling this situation. Can you please explain this in interviewer asking this question kindly give me the solution for this one?
good explanation sir
Thank you and keep watching
Fabulous
Thank you so much.. please share with your friends
Is it possible to show in the tool
I will try
Wt to do when we have flat file as source
Think 🤔
can you please explain regration testing,retesting ....etc for etl testers
Waiting for this topic sir,thank you so much
So nice of you... keep watching
And also XML transformation explain chesi and mapping tho explain cheyandi sir
Sure
Can you upload video for stored procedures sir? Better you can show us practically in informatica tool sir so that it should be more clear for everyone.
I will try
Which institute which city
No institute...
Sir u r videos are very usefull to everyone .explanation is also super .tq so much for uploading the videos
Thank you and Keep watching
Hi ALL, There was some issue in Audio. I will try to re upload new one
There is no audio in this video..kindly check and reupload for us
Let me check
Yes.I'm no't able video sound. Plz check it.Where the problem occurred.
I will try to re upload
Complete video does not have audio
XML transformation explain chesi and mapping tho explain cheyandi sir
Sure will try
Can you please give us an example with date for the Key portioning.Thanks
Sure will try
Hi one doubt if there are two target table one contain primary key and other contain foreign key how to set which target load first
It should be parent table always first
@@sureshetltrainer is there any option in target property to set up which target load first
@@sureshetltrainer your videos are really helpful thanks and keep posting such videos
@@priyankapatre38 enable constraint based load in session level
@@priyankapatre38 keep watching and share with your friends
What is exactly database partitioning...how do we configure it..
Say I have 10 partitions does each partition launches one session while execution. Session as in database session?
Thank u
Welcome
Great explanation Sir...!
Keep watching and thank you
ITS WORK AS SCD1,2 IS THERE IS ANY OTHER USE OF DYNAMIC CACHE?
It works as SCD 1 not scd2
@@sureshetltrainer yess I had try when attempting to insert duplicate into target wf fail due to insert into dynamic cache why lookup error