How to calculate the cache size if say we are doing a
performance check on a mapping and found that a particular
cache needs to be changed. Is there a formula to calculate
this! i know that informatica has a auto option available
but how to calculate manually?
What is intricate mapping?
What is router transformation
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
what is upstream and downstream transformation?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
When do you use mapping parameters? (In which transformations)
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
What is the filename which you need to configure in UNIX while installing infromatica?