Interested to Buy Any Domain ? << Click Here >> for more details...
How to load only the first and last record of a flat file into
the target?
- 3 Answers
- 9789 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / spandita
After SQ expre/aggregate without selecting group by option
then it displays default last record for displaying first
record there is first function enable this then it displays
1st record.....
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Define filter transformation?
Differentiate between Load Manager and DTM?
Differentiate between sessions and batches?
what is degenerated dimension?
Explain about Informatica server process that how it works relates to mapping variables?
State the differences between sql override and lookup override?
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.
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What are the performance considerations when working with aggregator transformation?
What is union transformation in informatica?
How many types of sessions are there in informatica.please explain them?
What are pre and post-session shell commands?
Define mapping and session?
How can we handle two sessions in informatica?
How to generate sequence numbers using expression transformation?
