Sriharsha Hanumanth

• Aug 23rd, 2005

1. PowerMart Designer 2. Server 3. Server Manager 4. Repository 5. Repository Manager

Answer Question  Select Best Answer

sampath

• Jul 24th, 2005

Rejection of records either at the database due to constraint key violation or the informatica server when writing data into target table.These rejected records we can find in the badfiles folder wher...

Answer Question  Select Best Answer

anjanroy

 Profile Answers by anjanroy Questions by anjanroy

• Apr 14th, 2006

There are pros and cons of both tool based ETL and hand-coded ETL. Tool based ETL provides maintainability, ease of development and graphical view of the flow. It also reduces the learning curve on th...

Answer Question  Select Best Answer

sree,prabhakar

• Jul 14th, 2006

Additve: A masure can participate arithmatic calulatons using all or any demensions.Ex: Sales profitSemi additive: A masure can participate arithmatic calulatons using some demensions.Ex: Sales a...

Answer Question  Select Best Answer

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 9th, 2006

Normally ETL Tool stands for Extraction Transformation Loader This helps you to extract the data from different ODS/Database, If you have a requirement like this you need to get the ETL tools, else you no need any ETLCheers,Sithu

Praveen

• Aug 14th, 2005

ETL Tools are meant to extract, transform and load the data into Data Warehouse for decision making. Before the evolution of ETL Tools, the above mentioned ETL process was done manually by using SQL c...

Answer Question  Select Best Answer

The DW database can be Oracle or Teradata. The requirement here is to pull data from source system and ETL need to device a mechanism to identify the changes or new records. The source system can be a legacy system like AS400 application or Mainframe application. List out all such methods of data capture. The ETL can be Informatica, data stage or custom etl code.

Sriram

• Jul 13th, 2007

Assuming this is a Type1 Dimension or a FACT table on the DWH - Create Date and Update Date will be 2 system dates captured and stored on the Datawarehouse. First time Creation_Dt = Update_Dt.&nb...

Answer Question  Select Best Answer

Doyel Ghosh Dutta

• Sep 16th, 2011

I think in microstrategy view can be reusable object.

Answer Question  Select Best Answer

srinivas vadlakonda

• Oct 17th, 2006

If u r taking connected we return the more than one port, in this we can use the static and dynamic cache and it will support the user defined values.If u r taking unconnected we return the only one port it will support only oracle with this we can use dynamic cache not static.

rajkumar

• Oct 10th, 2006

If return port only one then we can go for unconnected. More than one return port is not possible with Unconnected. If more than one return port then go for Connected.

Answer Question  Select Best Answer

komalahanumantharao

 Profile Answers by komalahanumantharao Questions by komalahanumantharao

• Dec 26th, 2007

Stop on errors=1 (if you set this option to 1 the session will be stopped after occurance of 1 error row. if it is 0 the  session will not be stopped even u got n number of errors.

Answer Question  Select Best Answer

sriluck

 Profile Answers by sriluck Questions by sriluck

• Mar 3rd, 2008

Global shortcuts are across multiple repositories,Local shortcuts are across multiple folders in the same repository.

Answer Question  Select Best Answer

If i delete one record in master table, then the same record is also deleted in dependent table, for this which transformation can we use.

jyothi_rayala

 Profile Answers by jyothi_rayala Questions by jyothi_rayala

• Feb 28th, 2011

In this case if the sources are relational then in DB while defining foreign key relation itself , if ON Delete Cascade is mentioned then automatically if master records are deleted child records also gets deleted

Answer Question  Select Best Answer

When can we use stored procedure transformations.

rohit.khatod

 Profile Answers by rohit.khatod Questions by rohit.khatod

• Sep 14th, 2008

Whenever you need value from SP, that time you have to use store pro. transformation. Or whenever you would like to preform some activity on the DB after loading the data or before loading data through ETL process. It can be done through Shell scripts as well.

Answer Question  Select Best Answer

can anybody tell me that what are the processes used by cognos and Informatica for ETL Extraction, Scrubbing and Fusion. If you have any detailed report then please send me onmy mail ID...nm_105@yahoo.co.inthanks in Advance...

raambharathi

 Profile Answers by raambharathi Questions by raambharathi

• Sep 16th, 2009

Cognos and Informatica are not same tool that does the same work.Informatica is a ETL tool.  It extracts data from various sources (Oracle, db2, Sybase, etc) transforms it and loads data into ...

Answer Question  Select Best Answer

What is the use of the User defined Environment variables?

veer.dwh

 Profile Answers by veer.dwh Questions by veer.dwh

• Sep 20th, 2009

User Defined Environment Variables are used to pass the parameters in job level,stage level and sequncer job level.Regards,Veeru.

Answer Question  Select Best Answer

What is the use of unconnected lookup transformation and exaplain with example?

pranambiar

 Profile Answers by pranambiar Questions by pranambiar

• Oct 26th, 2010

Informatica unconnected lookup can be taken as Oracle function. There are many scenario's in which unconnected lookup is preferred over connected one 1. When same lookup is to be used multiple tim...

Answer Question  Select Best Answer

jatin

• Feb 7th, 2013

Data-Centric Testing: Data-centric testing revolves around testing quality of the data. The objective of the data-centric testing is to ensure valid and correct data is in the system. Following are th...

Answer Question  Select Best Answer

suresh

• Jul 29th, 2015

Active and Passive Transformations:
Aggregator/Expression/Filter/Joiner/Rank/Router/Sequence Generator/Sorter/Source Qualifier/Union/Update Strategy Transformations

Answer Question  Select Best Answer

Why we use assignment task in Informatica and what happens after we used it?

Rathi

• May 7th, 2016

An Assignment Task is used to assign a value to a user-defined workflow variable.

Answer Question  Select Best Answer

How to get the below output for following table ? can you please clarify this
--------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------

--------------------------
100 | null | null | null
--------------------------

Swapna

• Apr 21st, 2016

SELECT MAX(COL1), MAX(COL2), MAX(COL3),MAX(COL4) FROM TABLE

Answer Question  Select Best Answer

How to generate a negative sequence by using sequence generator?

M Farhan

• Dec 29th, 2018

String_concat(-,next_insequence());

Answer Question  Select Best Answer