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
- 15592 Views
- Emirates, IBM, I also Faced
- E-Mail Answers
Answer Posted / bala
using sequence generator we can achieve desired result
enable SG properties as
start value=1
end value=5
enable cycle....
then in expression write a condition that
if SG values(num) are 1 and 5 then pass them into filter
iif(num=1 and num=5,true,false)
in filter ...make this column condition as true...
u will get every 1st and 5th record from your source
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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 is source qualifier transformation in informatica?
How to generate sequence numbers?
How can we update a record in the target table without using update strategy?
What is InformaticaPowerCenter?
Explain the different dimensions.
can anyone suggest best free Talend data integration training online
write a query to retrieve the latest records from the table sorted by version(scd)
without table how to come first record only in oracle?
How you prepared reports for OLAP?
Enterprise data warehouse your projects phase by phase explain?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is a surrogate key?
What is decode in informatica?
have u done any performance tuning? how u ll do?
