As union transformation gives UNION ALL output, how you will get the UNION output?
No Answer is Posted For this Question
Be the First to Post Answer
How to create or import flat file definition in to the warehouse designer?
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
What is the sql query overwrite in source qualifier in informatica
where does the default group roew in a router is stored what is the default size of memory in router
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)?
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
Describe the impact of several join conditions and join order in a joiner transformation?
what is sql override?what is the use of it?
why we r using presql&postsql in source qualifier?
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
What are the new features in Informatica 5.0?