Answer Posted / radhakrishnansk
write pl sql scripts
| Is This Answer Correct ? | 2 Yes | 10 No |
Post New Answer View All Answers
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Write the unconnected lookup syntax and how to return more than one column.
What is the difference between stop and abort in informatica
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is a rank transform?
How can you validate all mappings in the repository simultaneously?
What is joiner change?
What is deployment group?
write a query to retrieve the latest records from the table sorted by version(scd)
What are the different types of transformation available in informatica.
What is meant by lookup transformation? Explain the types of lookup transformation?
What are the advantages of informatica?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
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
