what is the incremental agrrigation?
Answers were Sorted based on User's Feedback
Answer / anoymous
It is technique used to get aggregated data incrementally,
can be done at session level.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / hemlata
The first time you run an upgraded session using
incremental aggregation, the Integration Service upgrades
the index and data cache files. If you want to partition a
session using a mapping with incremental aggregation, the
Integration Service realigns the index and data cache files.
| Is This Answer Correct ? | 1 Yes | 0 No |
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
how can u avoid duplicate rows in flat file?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
what are the row and column separations in Flat Files
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
how may sources can be used in a mapping at a time?(limit)
how to declare array in plsql?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
Without using any transformations how u can load the data into target?