Interested to Buy Any Domain ? << Click Here >> for more details...
If u r giving different parameter file names in workflow and
session for a single mapping parameter, then which one will
be executed? The one u given in workflow or the one u given
in the session?
- 1 Answers
- 6678 Views
- Hexaware, I also Faced
- E-Mail Answers
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
what are the output files that the informatica server creats during running a session?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
What is the Difference between sorter and aggregator?
What are the different options available for update strategy?
What are the session parameters?
What are the different types of schemas?
what is workflow varible
What are the scheduling options to run a sesion?
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
Teradata 
