I have 10 columns in a flat file and 10 rows corresponding to that columns.
I want column number 5 and 6 for last five records.
In unix as well as informtica.
No Answer is Posted For this Question
Be the First to Post Answer
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
one source to target loading insert new rows and update existing rows?
How can we handle two sessions in informatica?
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
Limitation of REPLACESTR. Is there any character limitation to it.
what is flat file override?
What is standalone command task?
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Which transformation should we use to normalise the COBOL and relational sources?
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
What do you mean by worklet?