in static and dynamic which one is better
Answers were Sorted based on User's Feedback
Answer / chansra
if source having duplicate rows then we can use
dynamic...otherwise we can use static
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chansra
if source having duplicate rows then we can use
dynamic...otherwise we can use static
| Is This Answer Correct ? | 0 Yes | 2 No |
How will you update the first four rows and insert next four rows in a mapping?
Can we create two repositories on same database instance in oracle?
How many dimensions are there in informatica?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Can we run session without using workflows?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
tell me about your project functionality
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
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
How to prepared lld.can any one tell me detailed explanetion.
What is the session task and command task?