A Router transformation is similar to a Filter transformation because both transformations allow you to use a condition to test data. However, a Filter transformation tests data for one condition and drops the rows of data that do not meet the condition. A Router transformation tests data for one or more conditions and gives you the option to route rows of data that do not meet any of the conditions...

Rksinghpathania

 Profile Answers by Rksinghpathania Questions by Rksinghpathania

• Jun 27th, 2007

Note:- i think the definition and purpose of Router transformation define by sithusithu, sithu is not clear and not fully correct as they of have mentioned <A Router transformation tests data for o...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

A Router transformation is similar to a Filter transformation because both transformations allow you to use a condition to test data. A Filter transformation tests data for one condition and drops the...

Answer Question  Select Best Answer

mohammed haneef

• Jun 28th, 2007

Hi,Joiner Cache will use in Joiner t/r  to improve the performance. While using joiner cache informatica server first read the data from master source and built data index & data cache in the...

Answer Question  Select Best Answer

madarapu

 Profile Answers by madarapu Questions by madarapu

• Jul 3rd, 2007

Yes we can if the soure and target is from same type of database then we can use a same odbc(dsn) for both of them.

Answer Question  Select Best Answer

Adil M

• Jul 4th, 2007

De-normalization is basically the concept of keeping all the dimension hierarchies in a single dimensions tables. This causes less number of joins while retriving data from dimensions and hence faster data retrival. This is why dimensions in OLAP systems are de-normalized.

Stephen Ross

• Mar 29th, 2007

I am a beginner to DW, but as I know fact tables - DenormalizedAnd Dimension Tables - Normalized.If I am wrong, please correct.

Answer Question  Select Best Answer

Adil M

• Jul 10th, 2007

This is because we cannot use a Non Reusable Sequence Generator Transformation in a mapplet. Hence we must use a Re usable Sequence Generator. The fact that we reuse mapplets has no bearing over why we should use a reusable SG.

madarapu

 Profile Answers by madarapu Questions by madarapu

• Jul 3rd, 2007

Since mapplet is to reusability so if we include  a sequence generator inside a mapplet.the mapplet which we r going to reuse it for next time the sequence generator properties would be changed.so that we can not recommend it inside a mapplet which gives inproper result set.

Answer Question  Select Best Answer

babu

• Jul 11th, 2007

In?above the condition satisfies is:1 satisfies A , A or B2?satisfies?B,?A or B1, 2?does not satisfies it goes to DEFAULTThere is no use of?A and B.

Answer Question  Select Best Answer

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Jul 24th, 2007

There is no such option available to send email when scheduled off. But we can select alternate for the same.Further @ sriram_kumar @ oneindia . in

Answer Question  Select Best Answer

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Jul 24th, 2007

First, you need to identify bottle necks, then mitigate them. then try to use options to avaoid/reduce the bottlenecks. so that you can imrove throughput.Further @ sriram_kumar @ oneindia . in

Answer Question  Select Best Answer

rasmi

 Profile Answers by rasmi Questions by rasmi

• Jul 31st, 2007

Commit interval is a interval in which the Informatica server loads the data into the target.

Answer Question  Select Best Answer

KB

• Jul 26th, 2007

If you want to save and reuse the cache files, you can configure the transformation to use a persistent cache. Use this feature when you know the lookup table does not change between session runs. Usi...

Answer Question  Select Best Answer

siraj.khan

• Aug 3rd, 2007

No it's not possible. source qualifier don't have any variables fields to utilize as expression.

premlahari

 Profile Answers by premlahari Questions by premlahari

• Dec 13th, 2005

No. we can't do. I will explain you why. 1) Unless you assign the output of the source qualifier to another transformation or to target no way it will include the feild in the query.2) source qualifier don't have any variables feilds to utalize as expression.

Answer Question  Select Best Answer

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Aug 10th, 2007

Cache look-up uses either Static or Dynamic cachesUnchached look-up uses static caches.

Answer Question  Select Best Answer

Maplet consists of set of transformations that is reusable.A reusable transformation is a single transformation that can be reusable. If u create a variables or parameters in maplet that can not be used in another maping or maplet.Unlike the variables that r created in a reusable transformation can be usefull in any other maping or maplet. We can not include source definitions in reusable transformations.But...

siraj khan

• Aug 6th, 2007

Mapplet is a group of reusable transformation.The main purpose of using Mapplet is  to hide the logic from end user point of view...It works like a function in C language.We can use it N number of times.Its a reusable object.Reusable transformation is a single transformation.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

Maplet: one or more transformationsReusable transformation: only one transformation Cheers,Sithu

Answer Question  Select Best Answer

pruthvi

• Aug 9th, 2007

Hierarchy in DWH is nothing but an ordered series of related dimensions grouped together to perform multidimensional analysis.

kalyan

• May 1st, 2006

Data sources ---> Data acquisition ---> Warehouse ---> Front end tools ---> Metadata management ---> Data warehouse operation management

Answer Question  Select Best Answer

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Aug 24th, 2007

By default there will be no name for the cache in lookup transformation.  Everytime you run the session, the cache will be rebuilt.  If you give a name to it, it is called Persistent Ca...

Answer Question  Select Best Answer

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Aug 27th, 2007

Once you create a shortcut, you can reuse it in the folder as often as necessary.?There are two types of short cuts: LOCAL & GLOBAL

Answer Question  Select Best Answer

mahesh

• Aug 26th, 2007

How can time dimension be a rapidly chnging dimensions. Time dimension is one table where you load date and time related information so that the key can be used in facts. this way you dont have to use...

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Sep 23rd, 2006

hibecuase time dimension is rapidly changing dimenction. if you use mapping it is very big stuff and that to be it very big problem in performence wise.thanksmadhu

Answer Question  Select Best Answer

THEJASWINI

• Sep 1st, 2007

$ - These are the system variables like $Bad file,$input file, $output file, $DB connection$$ - user defined variables$$$ - $$$SessStartTime $$$SessStartTime returns the initial system date value on t...

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Aug 27th, 2007

Generally, As I know. $ refers Session Parameters like $source,$target. $$ refers Mapping Parameters like $$State,$$Time. $$$ refers System Parameters like $$$SessStartTime. I am requesting any other in pool Please check & let me know if I was wrong.

Answer Question  Select Best Answer

Sujaya

• Sep 3rd, 2007

There is no default group in Filter Transformation. The records which does not satisfy filter condition are discarded and not written to reject file or session log file

babu

• Jul 11th, 2007

The rows which are not satisfing the filter transformation are discarded. It does not appear in the session logfile or reject files.

Answer Question  Select Best Answer

Can we use LEFT OUTER JOIN (ANSI SQL standard) in SQ query override with SAMPLE key word?(help me my dba used same in a mapping which have 5 rel SRCS from a single db and contain expression -- directed to TGT)

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Sep 7th, 2007

Adding to Mr. Sriram Kumar, As per the investigation I did with SAMPLE keyword in SQ trans......and fortunately its working.............Thx

Sriram Kumar N

• Aug 10th, 2007

You can use LEFT OUTER JOIN or RIGHT OUTER JOINS in source qualifier trans as SQL override. But make sure that you are not combining two or more outer joins using the same table as the inner table of more than one outer join.More information reach me @ sriram . kumar @ oneindia . in

Answer Question  Select Best Answer