Interested to Buy Any Domain ? << Click Here >> for more details...
i have to extract data from a flat file.the flat file has 10
records.i have to extract the 1st and 5th record every
time.how is it done.
- 10 Answers
- 14941 Views
- Emirates, IBM, I also Faced
- E-Mail Answers
Answer Posted / sanjay
1. Method
We can do it through
sq->Exp Trns->filter-->Target
!
SG
In filter trans by giving a condition "NUM=1
or NUM=5" we can get the result.
* But if you run the wf next time u need to change the NUM
value bcoz sq increments the value accrdng to the defined
condition whenever it runs the session.
2. Method
We can do it through Router trns
SQ—-Exp—Router--Target1 & Target2
!
SG
In Ist group NUM=1 & in 2nd group NUM=5.
where we'll define two groups, One for row 1 and other for
row 5.
* we need to chng the SG value every time
3. method
We can do it through parameters & variables
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is joiner transformation in informatica?
What is a connected transformation?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
What are the guidelines to be followed while using union transformation?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Differentiate between router and filter transformation?
What are the popular informatica products?
What is substr in informatica?
What is a node in Informatica?
Make a note of the quantity vaults made in informatica?
Can we create a Integration service without a Repository service and vice versa?
Why sorter is an active transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
Enlist the advantages of informatica.
What's the layout of parameter file (what does a parameter file contain?)?
