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!!!
Answer Posted / bala
@abhinav...
How can you sort records by using rownum...its not possible
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to join three sources using joiner?
How to join three sources using joiner? Explain though mapping flow.
Explain about Informatica server process that how it works relates to mapping variables?
How do you set a varible in incremental aggregation
what is the Default Source Option For Update Strategy Transformation?
Explain the mapping variable usage example in informatica
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.
State the limitations where we cannot use joiner in the mapping pipeline?
What are roles and groups and benefits of using them?
Did u used latest transformations of 8.6.0? for what?
What is union transformation?
How to improve the performance of a session using sorter transformation?
How do you load unique records into one target table and duplicate records into a different target table?
What is resilience time?
What is the difference between writing a joiner query in ANSI style and THETA style?