lathasurendar

• Jul 23rd, 2006

Changed Data Capture (CDC) helps identify the data in the source system that has changed since the last extraction. With CDC, data extraction takes place at the same time the insert, update, or delete...

Bala

• Jul 21st, 2006

Can you eloberate on how do you this pls?

Answer Question  Select Best Answer

Praveen kumar

• Jul 22nd, 2006

Unit testing are of two types1. Quantitaive testing 2.Qualitative testingSteps.1.First validate the mapping2.Create session on themapping and then run workflow.Once the session is succeeded the right ...

Answer Question  Select Best Answer

Aparna

• Jul 18th, 2006

The unconnected lookup is used just like a function call. in an expression output/variable port or any place where an expression is accepted(like condition in update strategy etc..), call the unconnec...

Answer Question  Select Best Answer

prasadns26

 Profile Answers by prasadns26 Questions by prasadns26

• Jul 18th, 2006

hi,what ever said by rishi is correct,info can be used as a cleansing tool.usually EXP is used for cleaning data using data cleansing functions and other functions present in infa.eg,assign default va...

Rishi

• Dec 5th, 2005

Yes, we can use Informatica for cleansing data. some time we use stages to cleansing the data. It depends upon performance again else we can use expression to cleasing data.For example an feild X...

Answer Question  Select Best Answer

prasadns26

 Profile Answers by prasadns26 Questions by prasadns26

• Jul 18th, 2006

hi,see informatica is basically a integration tool.it all depends on the source u have and ur requirment.if u have a EMS Q, or flat file or any source other than RDBMS, u need info to do any kind of a...

Rishi

• Dec 5th, 2005

It depends upon our requirment only.If you have good processing database you can create aggregation table or view at database level else its better to use informatica. Here i'm explaing why we need to...

Answer Question  Select Best Answer

prasadns26

 Profile Answers by prasadns26 Questions by prasadns26

• Jul 18th, 2006

hi,we can stop it using PMCMD command or in the monitor right click on that perticular session and select stop.this will stop the current session and the sessions next to it.

vasulu

• Feb 17th, 2006

we have a task called wait event using that we can stop.we start using raise event.this is as per my knowledge.

Answer Question  Select Best Answer

prasadns26

 Profile Answers by prasadns26 Questions by prasadns26

• Jul 18th, 2006

hi,while importing flat file definetion just specify the scale for a neumaric data type. in the mapping, the flat file source supports only number datatype(no decimal and integer). In the SQ associate...

gauravkant

 Profile Answers by gauravkant Questions by gauravkant

• Feb 13th, 2006

You can handle that by simply using the source analyzer window and then go to the ports of that flat file representations and changing the precision and scales.

Answer Question  Select Best Answer

Prasad

• Jul 14th, 2006

Hi,1> Native connection is something which is provided by the same vendor for that tool. eg: oracle warehouse builder has its own driver to connect to oracle DB which does not use a ODBC driver. here ...

Answer Question  Select Best Answer

Prasad

• Jul 14th, 2006

Hi,We can use a MQSeries SQ when we have a MQ messaging system as source(queue).When there is need to extract data from a Queue, which will basically have messages in XML format, we will use a JMS or ...

kalyan

• May 1st, 2006

its like same as Source Qualifier but only for MQ Series Product from IBM. This product is used for Data Integration from different type of databases and to provide them as single source of data.

Answer Question  Select Best Answer

Prasad

• Jul 14th, 2006

Hi,In the requirment collection phase, all the attributes that are likely to be used in any dimension will be gathered. while creating a dimension we use all the related attributes of that dimesion fr...

raghavendra

• Apr 17th, 2006

Junk Dimension A Dimension is called junk dimension if it contains attribute which are rarely changed ormodified. example In Banking Domain , we can fetch four attributes accounting to a junk dimens...

Answer Question  Select Best Answer

Prasad

• Jul 14th, 2006

Hi,Cache is stored in the Informatica server memory and over flowed data is stored on the disk in file format which will be automatically deleted after the successful completion of the session run. If you want to store that data you have to use a persistant cache.

shekar25_g

 Profile Answers by shekar25_g Questions by shekar25_g

• Apr 15th, 2006

Cache stored in informatica is in informatica server.

Answer Question  Select Best Answer

Prasad

• Jul 14th, 2006

hi,if u r using a update strategy in any of ur mapping, then in session properties u have to set treat source rows as Data Driven. if u select insert or udate or delete, then the info server will not ...

windows

 Profile Answers by windows Questions by windows

• Jun 2nd, 2006

You can set the following update strategy options: Insert. Select this option to insert a row into a target table. Delete. Select this option to delete a row from a table. Update. You have three diffe...

Answer Question  Select Best Answer

Prasad

• Jul 14th, 2006

hi,use a lookup for this. consider ur targer table as the lookup table.check for the existence. and use the session level properties. select treat source rows as update and in mapping tab->target v...

Shanmugam

• Jul 6th, 2006

You can use the incremental loading concept. Store the last_run_date as SYSDATE each time you run the session in an variable and use it next time you load your target.

Answer Question  Select Best Answer

Prasad

• Jul 14th, 2006

what ever is said above is correct. Just add 2 dummy ports in the joiner transformation with the same datatypes(Integer). one dummy port as detail and other as master.Then assign both the ports d...

kumar

• Jun 11th, 2006

Could you please briefly explain on this?

Answer Question  Select Best Answer

Prasad

• Jul 14th, 2006

hi,u can start from the 3rd session by right clicking on that session and select "start workflow from this task".This will ensure that the workflow has started to run from 3rd session and continues till the last one.

windows

 Profile Answers by windows Questions by windows

• May 23rd, 2006

If multiple sessions in a concurrent batch fail, you might want to truncate all targets and run the batch again. However, if a session in a concurrent batch fails and the rest of the sessions complete...

Answer Question  Select Best Answer

abc

• Jul 14th, 2006

By using command task.

Answer Question  Select Best Answer

Sridhar.B

• Jul 12th, 2006

The "Slowly Changing Dimension" problem is a common one particular to data warehousing. In a nutshell, this applies to cases where the attribute for a record varies over time. We give an example below...

priyamayee

 Profile Answers by priyamayee Questions by priyamayee

• Jun 8th, 2006

Hii, It depends on the business requirement u have. We use this SCD's to maintain history(changes/updates) in the dimensions. Each SCD type has it's own way of storing/updating/maintaining the history...

Answer Question  Select Best Answer

bala

• Jul 6th, 2006

Hi,   Informatica is a ETL tool.used for the Extraction,Transformation and Loadind of data.This tool is used to Extract the data from different Data Bases and then we can do the required tra...

Answer Question  Select Best Answer

Shanmugam

• Jul 6th, 2006

To optimize the aggregator transformation, you can use the following options.Use incremental aggregationSort the ports before you perform aggregationAvoid using aggregator transformation after update strategy, since it might be confusing.

Guru

• May 25th, 2006

T1 and T3 are being the master table and don't have any foreign key refrence to other table will be loaded first. Then T3 will be loaded as it's master table T3 is already been loaded. ...

Answer Question  Select Best Answer

Motilal

• Jun 30th, 2006

Ya its the level of information storage in session log.The option comes in the properties tab of transformations. By default it remains "Normal". Can be Verbose InitialisationVerbose DataNormal or Terse.

rajesh

• Jun 21st, 2006

Tracing level determines the amount of information that informatcia server writes in a session log.

Answer Question  Select Best Answer