What is the status code in stored procedure transformation?
No Answer is Posted For this Question
Be the First to Post Answer
What are the different tools in workflow manager?
I want skip first 5 rows to load in to target? what will be the logic at session level ??
What is Performance tuning in Informatica?
Write the advantages of partitioning a session?
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
What is the Difference between sorter and aggregator?
Is it possible to use a client with different version than that of its Informatica server?
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
How can i set break points in debugging mode ? can explain steps please?
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
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?