Answer Posted / rajbir
We use stored procedure transformation top evalate the
expression for rows at database level so that we can use it
again n again according to our requirment
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What happens when a session fails and you click on recover?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Name the different lookup cache(s)?
What are the main features of Oracle 8i with context to datawarehouse?
How to Create a folder using pmrep command?
How can we use mapping variables in informatica? Where do we use them?
How many ways are there to create ports?
What are the different options available for update strategy?
Briefly define a session task?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How many numbers of sessions can one group in batches?
What do you mean by blocking transformation?
Which version configuration tool used in ur project?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me