Interested to Buy Any Domain ? << Click Here >> for more details...
When will you use SQL override in a lookup transformation?
- 1 Answers
- 5687 Views
- I also Faced
- E-Mail Answers
Answer / vanita
For filtering the data in lookup table using where clause, or joing multiple tables to select data or to change the default order by clause with your own order by clause
| Is This Answer Correct ? | 10 Yes | 0 No |
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
what is scd?
How do you load first and last records into target table?
How many mapplets u have created? and what is the logic used
why we are using surogate key in real time give me explanation
without dynamic lookup transformation how to insert new rows and update existing rows?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is sq transformation?
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
waht type of interface is used for testing the data in informatica
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
Teradata 
