1)how to generate sequnce numbers in informatica without
using sequnce genarator transformation.
2)i have number of records in my sourse, but iwant to
display first and last record only. how it is possible in
informatica.
3)i want to update the records without using updatestrategy
transformation.
4)what is diffrance between ab-intio and datastage than
compared to informatica.
5)what is the latest version of informatica in our field.
Answer Posted / chandrasekar
HI VENKATESH,
YOUR ABOVE ANSWER IS NOT CORRECTLY WORKING IN MY
SYSTEM. SO PLEASE EXECUTE THE ABOVE SOLUTION ONCE AGAIN LOAD
IT. AS PER MY KNOWLEDGE WE CAN CREATE A MAPPING VARIABLE AS
$$SEQ,DATA TYPE IS INTEGER AND SELECT AGGREGATION COLOUMN IS
COUNT. USING EXP TRANSFORMATION SETCOUNTVARIABLE($$SEQ). IT
WILL WORK CORRECTLY.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the Rank index port in Rank transformation?
can anyone explain me about retail domain project in informatica?
Describe the impact of several join conditions and join order in a joiner transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What do you mean by enterprise data warehousing?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is meant by a domain?
What is meant by pre and post session shell command?
How many dimensions are there in informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How do you change a non-reusable transformation to reusable transformation?
What is an Integration service in Informatica?
What are pre and post-session shell commands?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance