How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
- 0 Answers
- 1336 Views
- I also Faced
- E-Mail Answers
How can we use batches?
can every transfomation reusable?how?
how u know when to use a static cache and dynamic cache in lookup transformation.
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
what happens if you try to create a shortcut to a non- shared folder?
How to identify this row for insert and this row for update in dynamic lookup cache
How to do unit testing in informatica? How to load data in informatica ?
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
can we override a native sql query within informatica? Where do we do it?
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
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?
Teradata 
