Explain lookup transformation in informatica
No Answer is Posted For this Question
Be the First to Post Answer
what is confirmed dimension?
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
What are the mapping paramaters and mapping variables?
What is rank index in rank transformation?
how to get flatfile containg 10 records half records one target another half another target
Explain sessions?
without update strategy how to insert &update?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
How You Pull the records on daily basis into your ETL Server.