Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)
Crystal Enterprise Suite (30)
Actuate (46)
Ab Initio (442)
Data Stage (917)
SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)
IBM Cognos TM1 (55)
Amazon Redshift (62)
Data Warehouse General (749) how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
6 17975wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
CTS,
1 9117we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....
IBM,
1 6643
Write the unconnected lookup syntax?
Are you involved in writing the inferential analysis plan? Tables specifications?
what are the data modeling tools you have used?(polaris)
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 dimensional table? Explain the different dimensions.
What is rollup component?
Explain in detail about scd type 1 through mapping.
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
Explain what is aggregate table and aggregate fact table ... Any examples of both?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
What is the purpose of Dataware Control?
What is dimensional table?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
What is node? How many nodes and amps used in your previous project?
Explain how to generate iqd file from framework manager?