how to insert header after each group.
Answer / rohit
I have below records.
EMPID,Name
101,car
101,car
102,Bus
103,Flight
103,Flight
103,Flight
103,Flight
104,Ship
output:-
101,car
101,car
#----------#
102,Bus
#----------#
103,Flight
103,Flight
103,Flight
103,Flight
#----------#
104,Ship
Is This Answer Correct ? | 0 Yes | 0 No |
Differentiate between reusable transformation and mapplet.
What is the Difference between DSS & OLTP?
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
What is a filter transformation and why it is an active one?
what is junk dimension
we have to use order by,where,having we to implement sql query
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
WAT IS TEXT LOAD?
What is hash partition?
How to do Integration testing in Informatica?
What are active transformations.
How can you increase the performance in joiner transformation?