what are factless facts? And in which scenario will you use such kinds of fact tables.
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between normal and bulk loading? Which one is recommended?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
How will you update the first four rows and insert next four rows in a mapping?
Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that
What is lookup transformation?
How do you load only null records into target?
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
can we override a native sql query within informatica? Where do we do it? How do we do it?
I want skip first 5 rows to load in to target? what will be the logic at session level ??
What are the types of maping in Getting Started Wizard?