Which type or t/s is used to convert rows into column &
column into rows
Answer Posted / pradeep sharma
this is easily achievable in talend also using the normalize and textract delimited field
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how do u set partition points in the mapping?
tell me few points when u become TL
what are the concerns of OLTP and DSS systems?
What is grain of fact?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
What are the etl testing operations includes?
What is a mapping, session, worklet, workflow, mapplet?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
what is pmrep command?
What is partitioning? Explain about round-robin, hash partitioning.
What are three tier systems in etl?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What is the difference between round-robin partitioning and hash partitioning?
how would u estimate the size of Lookup transform data and index cache?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?