which one is better performance wise joiner or look up
No Answer is Posted For this Question
Be the First to Post Answer
Write the different tools in the workflow manager?
we have to use order by,where,having we to implement sql query
how u know when to use a static cache and dynamic cache in lookup transformation.
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?
What is the need of etl tools?
How many numbers of sessions can one group in batches?
what is normalizer transformation?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
what is data driven?
What is the status code in stored procedure transformation?
what is fact table?
Normalizer transformation is not involved in Mapplet.. why???