Interested to Buy Any Domain ? << Click Here >> for more details...
can we load the data with out a primary key of a table?
what is target plan?
- 6 Answers
- 14888 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / manjunath
Yes, we can load the data without the primary key, but if you want to use furhtet i.e to update we cant do it, for that we need primary key.
Target Load Plan : It is used if we have multiple sources and targets we go for this option (We can have this option in Mapping Tab)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many number of sessions can one group in batches?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is rank transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Explain the difference between mapping parameter and mapping variable?
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
tell me about your project functionality
How we can use union transformation?
What is an expression transformation?
Sequence generator, when you move from develoment to production how will you reset
Explain about cumulative Sum or moving sum?
What all join we can perform in LOOKUP transformation?
