if i have a delimited file as source so how can we seperate this file into three diff targets?
Answers were Sorted based on User's Feedback
Answer / lakshmi
using expression ,transaction control transformations
| Is This Answer Correct ? | 0 Yes | 0 No |
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
What is the role of informatica in project ?Like i showed financial projects?
How union transformation is active ?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
without using emailtask how will send a mail from informatica?
In how many ways we can create ports?
How can u stop a batch?