How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)
Answer Posted / babu
u can write the filter condition in filter t/r.
in aggregator t/r select all ports are group by and add one
out put port,that is out--count(*),
in filter t/r u cam place the condition is out=1;
mapping:
src->sq->agg(t/r)->filtr or router t/r->trg
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
how to load dimension table and fact table. plz tell me the steps.
How to update or delete the rows in a target, which do not have key fields?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
According to his methodology what all you need before you build a datawarehouse
What is the difference between STOP and ABORT options in Workflow Monitor?
Explain the types of lookup transformation?
How to configure mapping in informatica?
What is the meaning of decode in informatica?
What are the limitations of joiner transformation?
Describe an informatica powercenter?
How to do the error handling of if ur source is flatfiles?
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
Explain lookup transformation in informatica