By using joiner t/r we can join only 2 tables, SO if want
join more than 2 flat files ,How can i join?
Answer / rahul
for n source we required n-1 joiner t/r.
ex: if we have 3 flat file dan we requried 2 joiner t/r
Is This Answer Correct ? | 16 Yes | 0 No |
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!!!
What are the data movement modes in informatcia?
How do you use reject loader.
what is pre and post sql and what is diff between source presql and target pre sql
-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?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
can we override a native sql query within informatica? Where do we do it?
Define informatica repository?
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
what are cost based and rule based approaches and what is the difference?
what is incremental aggregation ,with example?