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
Can we get 1st record through Informatica(without sequence number).
What is dynamic cache?
Can we create multiple integration service on single repository?
Briefly define a session task?
What is sorter transformation?
Differentiate between reusable transformation and mapplet.
scenario where i can use only concurrent execution of workflow.
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How do we call shell scripts from informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How can one identify whether mapping is correct or not without connecting session?
Which version configuration tool used in ur project?
How does the aggregator transformation handle null values?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???