Interested to Buy Any Domain ? << Click Here >> for more details...
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
- 1 Answers
- 6702 Views
- iNautix, I also Faced
- E-Mail Answers
Answer / joe
s...rank1 (for header)-top option..........Target1
.
.....Aggregator (Count(lastcolumn))........Target2
.
....rank2(for footer)-bottom option........Target3
| Is This Answer Correct ? | 0 Yes | 5 No |
Why sorter is an active transformation?
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
I want load the data into target with out 1st and last record.
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
What is Java Transformation? what are the uses of it?
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
Can you generate reports in Informatcia?
What are Target Options on the Servers?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
Teradata 
