Reusable transformations can be used in multiple mappings.When u need to incorporate this transformation into maping,U add an instance of it to maping.Later if U change the definition of the transformation ,all instances of it inherit the changes.Since the instance of reusable transforamation is a pointer to that transforamtion,U can change the transforamation in the transformation developer,its instances...

devaranr

 Profile Answers by devaranr Questions by devaranr

• Apr 12th, 2007

1. A reusable transformation can be used in multiple transformations2.The designer stores each reusable transformation as metada separate from   any mappings  that use the transformatio...

zaki

• Apr 1st, 2007

Hai to all friends out therethe transformation that can be reused is called a reusable transformation.as the property suggests it has to be reused:so for reusing we can do it in two different ways 1) ...

Answer Question  Select Best Answer

The Designer provides two mapping wizards to help you create mappings quickly and easily. Both wizards are designed to create mappings for loading and maintaining star schemas, a series of dimensions related to a central fact table. Getting Started Wizard. Creates mappings to load static fact and dimension tables, as well as slowly growing dimension tables. Slowly Changing Dimensions Wizard. Creates...

raj

• Apr 13th, 2007

Inf designer :Mapping ->  wizards -->  1) Getting started -->Simple pass through mapping               &nb...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 9th, 2006

Simple Pass through Slowly Growing Target Slowly Changing the Dimension Type1Most recent values Type2Full HistoryVersionFlagDate Type3Current and one previous

Answer Question  Select Best Answer

Rohith Yogendra

 Profile Answers by Rohith Yogendra Questions by Rohith Yogendra

• Apr 20th, 2007

CREATE OR REPLACE  PROCEDURE TIMEDIMBUILD   (p_start_date IN DATE,  p_end_date IN DATE)AS  v_full_date DATE;  v_day_of_month NUMBER; v_day_of_year NUMBER;  v_da...

Rohith Yogendra

 Profile Answers by Rohith Yogendra Questions by Rohith Yogendra

• Apr 20th, 2007

Hi this would be the normal SP Code that i use to populate a time dimension,well again it depends on the business requirements to know what level the Grain is required for a time dimensionCREATE OR RE...

Answer Question  Select Best Answer

When a Joiner transformation occurs in a session, the Informatica Server reads all the records from the master source and builds index and data caches based on the master rows. After building the caches, the Joiner transformation reads records from the detail source and perform joins.

bneha15

 Profile Answers by bneha15 Questions by bneha15

• Apr 23rd, 2007

For version 7.x and above :When the PowerCenter Server processes a Joiner transformation, it reads rows from both sources concurrently and builds the index and data cache based on the master rows. The...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

Specifies the directory used to cache master records and the index to these records. By default, the cached files are created in a directory specified by the server variable $PMCacheDir. If you overri...

Answer Question  Select Best Answer

say2joshi

 Profile Answers by say2joshi Questions by say2joshi

• Apr 24th, 2007

Hiwe can set the max no of concurrent session in informatica service. by default it is 10 sessions.thanks

pavithra

• Dec 17th, 2006

Hi,we set in informatica server where we have option called 'max. no of concurrent session '

Answer Question  Select Best Answer

If you have column name as f_name in which the data is "john&","97edward","do__nna" . you want to remove/replace the special characters and then send the output as "john","edward","donna" to the target. what is the transformation and what is the function to be used in the mapping(informatica)

sivakumar

• May 2nd, 2007

It is not possible

Answer Question  Select Best Answer

hanug

 Profile Answers by hanug Questions by hanug

• May 8th, 2007

U can use the scripting(either UNIX shell or Windows Dos scripting) and then schedule the script.Hanu.

Answer Question  Select Best Answer

hanug

 Profile Answers by hanug Questions by hanug

• May 8th, 2007

Hi:Trigger can not be called from Stored procedure. Trigger will execute implicitly when u are performing DML operation on the table or view(instead of views).U can get the difference between trigger and sp anywhere in the doc.Hanu.

Answer Question  Select Best Answer

hanug

 Profile Answers by hanug Questions by hanug

• May 8th, 2007

We can create them manually or use the slowly changing dimension wizard to avoid the hassels.Use slowly changing dimension wizard and make necessary changes as per your logic.Hanu.

Answer Question  Select Best Answer

What is the use of BUSINESS COMPONENT object ? When do we use them?

SRIRAM N

• May 9th, 2007

Business component object is used to categorise the objects.

Answer Question  Select Best Answer

SRIRAM N

• May 9th, 2007

If you want to run same workflow then schedule it.If you want to run workflow 2 after work flow 1 then, use post session command script to create?a 'successfile.dat' or 'failfile.dat' file in a locat...

dontknow

• Jan 11th, 2007

I am typing this bcos i think this is your question..I think u wanna scheule a second workflow after the success of first workflow ?If this is the Q, Then 1)You can't start second workflow after ...

Answer Question  Select Best Answer

SRIRAM N

• May 9th, 2007

Custom transformation To extend the powercenter functionality by using outside developed procedures. You can create Custom transformations with multiple input and output groupsFor any queries: sriram_kumar @ one...

Answer Question  Select Best Answer

SRIRAM N

• May 9th, 2007

DIMENSION means an attribute or characteristic or behaviourDIMENSION TABLE means a table contains different dimensions.

yvreddy

• Dec 30th, 2006

hai,dimension table having more number of attributes(dimension) where as dimension is single attributeyvreddy

Answer Question  Select Best Answer

SRIRAM N

• May 9th, 2007

SESSIONSession tells the server, how to fetch the metadata from repository for the specified mapping (data flow).TASK Task is a particular work that is for eg. Assignment Task is used to assign a value to the variable for the entire workflow.Still confusion then Wrtie me: nalla_ramsri @ yahoo . com

lingesh

• Oct 11th, 2006

Hi,    what is session?       When ever u create session it will ask for map which it has to link.For each seesion we can have one map to link with session...

Answer Question  Select Best Answer

SRIRAM N

• May 9th, 2007

For relational lookups, you might want to configure the transformation to use a dynamic cache when the target table is also the lookup table. The PowerCenter Server builds the cache when it processes ...

Manisha

• Dec 14th, 2006

Dynamic Lookup is used when the table on which we are performing lookup is being written into. A very common example is when we lookup the Target table to deicde if a particular row is for Insert/upda...

Answer Question  Select Best Answer

vinodh259

 Profile Answers by vinodh259 Questions by vinodh259

• May 11th, 2007

provide optimizer hints to the informatica. such as force informatica to use indexes, synonyms, etc ..best technique is find ehich trnsformation is makin the mapping slow and  with that logic bui...

Answer Question  Select Best Answer