How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
TCS,
5 10071If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
TCS,
2 7717my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
2 7148If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
2008Post New Informatica Questions
What is blocking transformation?
What are the different components of powercenter?
What is the benefit of partitioning a session?
what is the difference between informatica6.1 and infomatica7.1
What do you mean by channel change?
How to configure mapping in informatica?
What if the source is a flat-file?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
tell me about your project functionality
What is an active transformation?
What are the measure objects?
In warehouses how many schemas are there?
What is dimensional table?
Explain target update override in informatica