from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data
1. Joiner
2 No cache
3. Static
4. Dynamic
Answers were Sorted based on User's Feedback
What is the filename which you need to configure in UNIX while installing infromatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
what is difference between mapping and mapplet ?
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Name the different lookup cache(s)?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is the term PIPELINE in informatica ?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio