Interested to Buy Any Domain ? << Click Here >> for more details...
My source has 100 records. I have targets say in number 5.
all target tables has parent and child relationships in
between themselves. Now I want to load all 100 records into
all targets. How U can ensure that record inserted in parent
and then loaded into child.
- 3 Answers
- 9662 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / veeru
use the constrinat based loading order in session level and
set the dependency
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain the difference between a data warehouse and a data mart?
How to Create a folder using pmrep command?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
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
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Explain your project of banking domian.
Can we change Dynamic to Static or Persistent cache? If so what happens?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Define filter transformation?
How can we update a record in the target table without using update strategy?
What is expression transformation?
Define pmcmd command?
What are the different types of repositories created using informatica?
