how remove 1st 3 records & last 3 records in informatics
Answer Posted / venky
after sq transformation use exp transformation in that add
one port,and take seq generator trans and its properties
reset is enable,and link to the port in exp trans,after
that take filter trans and condition port>3,after that use
sorter trans in that take port desc,after that take exp
trans and create another new port,after that take seq gen
trans in properties resert as enable and link to the new
port,afer that use filter trans condition new port>3 and
connect to target.
this is the process u can do u wil get the result.pls try it
correctly
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Describe data concatenation?
can u give example for factless fact table
Briefly define reusable transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the basic requirements to join two sources in a source qualifier transformation using default join?
expain about the tune parameters?
How do you handle two sessions in Informatica
What is the command used to run a batch?
What do mean by local and global repository?
what is $$$$?
How to create the source and target database connections in server manager?
Define pmcmd command?
How are the sources and targets definitions imported in informatica designer?
update strategy transformation in informatica