HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND
LOOKUP?
Answers were Sorted based on User's Feedback
without update strategy how to insert &update?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is a code page?
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
How many number of sessions that u can create in a batch?
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
What is informatica powercenter repository?
What is meta data and system catalog?
How you prepared reports for OLAP?
What is galaxy shema
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
I have a flat file, want to reverse the contents of the flat file