Interested to Buy Any Domain ? << Click Here >> for more details...
how can we perform incremental aggregation?explain with
example?
- 9 Answers
- 23373 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / friend
He explained in Practical manner, so if your strong in
technical you can understand otherwise ..... and plz don't
discourage others
| Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
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
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
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.
Which is the t/r that builts only single cache memory?
How can we improve session performance in aggregator transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
which one is better performance wise joiner or look up
What all are steps in up gradation of Informatica server?
Explain target update override in informatica
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Whats the difference between informatica powercenter server, repositoryserver and repository?
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
Is it possible to revert a global repository to local one and why?
How can one identify whether mapping is correct or not without connecting session?
How do you remove duplicate records in informatica? And how many ways are there to do it?
