Interested to Buy Any Domain ? << Click Here >> for more details...
If one flat file contains n number of records., we have to
load the records in target from 51 to 100.. how to use
expressions in Informatica..?
- 6 Answers
- 15803 Views
- I also Faced
- E-Mail Answers
Answer Posted / palani
Yes. For better performance filter the records using Unix's
Head,Tail commands. Pass the particular records to SQ and
Load.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the transformations that are not supported in mapplet?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
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 a grid in Informatica?
What is the procedure for creating independent data marts from informatica 7.1?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How many dimensions are there in informatica?
what are 3 tech challenges/ common issues you face?
Enlist some properties of sessions.
What are the different types of olap? Give an example?
Parameter and variable differences
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are mapplets? How is it different from a Reusable Transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
