Interested to Buy Any Domain ? << Click Here >> for more details...
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
- 1 Answers
- 3478 Views
- Franklin Templeton, I also Faced
- E-Mail Answers
Answer / dilip ingole
use sql override in SQ
ans use query as fellow
SELECT NUM,CASE WHEN ROWNUM <=(SELECT COUNT(1)/2 FROM TABLE_NAME) THEN 1 ELSE 0 END FLAG FROM TABLE_NAME;
in informatica filter record based on flag if flag is 1 then send it to one target else to second target
| Is This Answer Correct ? | 0 Yes | 0 No |
how to load rows into fact table in data warehouse
Explain the mapping variable usage example in informatica
explain abt joiner t/r?
What's the layout of parameter file (what does a parameter file contain?)?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
Describe an informatica powercenter?
What is power center repository?
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
if i have a delimited file as source so how can we seperate this file into three diff targets?
What are the session parameters?
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
Teradata 
