Which transformation should u need while using the cobol
sources as source defintions?
Answers were Sorted based on User's Feedback
Answer / swetha
Normalizer transformaiton which is used to normalize the
data. Since cobol sources r oftenly consists of
Denormailzed data.
| Is This Answer Correct ? | 1 Yes | 0 No |
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
What are the Differences between static cache and dynamic cache?
What are the different types of Type2 dimension maping?
What if the source is a flat-file?
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
what is the diff b/w target load plan and cbl?
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
Why we select the table which has minimum number of records as Master table in joiner?