Interested to Buy Any Domain ? << Click Here >> for more details...
when should one create lookup transformation ?
- 2 Answers
- 5574 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kaki
Look up transformation is used for looking up a value from
OLAP table within a mapping before populating it. For
example, I have empid and I want to get emp name to use in
the next transformation, I would search for it in a look up
table which has the emp name by giving input as emp id.
| Is This Answer Correct ? | 1 Yes | 0 No |
how do u decide whether u need to do aggregations at database level or at Informatica level?
Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks
what is session partitioning?
What are the ETL Testing Operations?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
Difference between flat files and relational sources?
what is the meant by Normalization and de-normalization?
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
Explain about the data integration suite features?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
What is full load & incremental or refresh load?
how do u implement scheduling in Informatica?
Teradata 
