Interested to Buy Any Domain ? << Click Here >> for more details...
How can a Lookup with Dynamic Cache be replaced in a
mapping? Explain.
- 2 Answers
- 7785 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
A lookup with Dynamic cache can be replaced by an SQL
override query in the transformation itself which will run
each time there is load of data during the run of the
Workflow.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / qamar
I suppose the answer to this question is by using Joiner
transformation.
| Is This Answer Correct ? | 1 Yes | 0 No |
how to insert header after each group.
How will u pas the data with out debugger?
How to join three sources using joiner?
What is joiner cache?
What is the difference between router and filter?
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
What aer the out put files that the informatica server creates during the session running?
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 is the difference between stop and abort?
what is diff between grep and find
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
What is status code in informatica?
Teradata 
