Interested to Buy Any Domain ? << Click Here >> for more details...
If we have 1000 rows were loaded in to datawarehouse and
next day the source have 1010 rows so, how can we loaded
only updated rows into target.
- 6 Answers
- 12332 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / mahipal reddy
By selecting 'UPDATE' in the 'Treat source data as:'from
session properties we can get only updated rows..
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What are the new features of Power Center 5.0?
Differentiate between sessions and batches?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Mention few advantages of router transformation over filter transformation.
What is the difference between source qualifier transformations source filter to filter 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 is target designer and target load order?
What are the new features of informatica 9.x developer?
During the running session, output files are created by informatica server. Enlist few of them.
Describe the impact of several join conditions and join order in a joiner transformation?
What are the different components of powercenter?
What does update strategy mean, and what are the different option of it?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
