Interested to Buy Any Domain ? << Click Here >> for more details...
in my lookup table i want to catch the recently updated
records from the source to target,how to achieve this and what
is last commit interval point for this?
- 2 Answers
- 6858 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
what is the purpose of surrogate key and diff between primary key&surrogate key
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
What are ETL Tools?
What is the command used to run a batch?
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
State the limitations where we cannot use joiner in the mapping pipeline?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
what is normalizer transformation?
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
Teradata 
