Interested to Buy Any Domain ? << Click Here >> for more details...
how remove 1st 3 records & last 3 records in informatics
- 4 Answers
- 9755 Views
- TetraSoft, I also Faced
- E-Mail Answers
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
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is decode in informatica?
list out all the transformations which use cache?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
On which transformations you created partitions in your project?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
difference between informatica 8.1.1 and 8.6
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is transformation?
What is Cognos script editor?
Write the unconnected lookup syntax and how to return more than one column.
What are the different types of transformation available in informatica.
What is intricate mapping?
