How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
TCS,
5 9887If 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 7606my 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 7033If 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
1941Post New Informatica Questions
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How to generate or load values in to the target table based on a column value using informatica etl tool.
How we can create indexes after completing the loan process?
What is the use of source qualifier?
What is target designer and target load order?
What are the informatica performance improvement tips
What is substr in informatica?
How can you generate reports in informatica?
How would you join a node to the already existing domain?
Differences between connected and unconnected lookup?
what is mean by complex business rule ?
Global and Local shortcuts. Advantages.
Explian the Process of deployment groups in informatica
tell me about your project functionality
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records