Prasad Parulekar

• May 14th, 2007

Use session parameters to make sessions more flexible. For example, you have the same type of transactional data written to two different databases, and you use the database connections TransDB1 and...

sm1506

• Apr 12th, 2006

HiYou are supposed to define a parameter file. And then in the Parameter file, you can define two parameters, one for source and one for target.Give like this for example:$Src_file = c:\program f...

Answer Question  Select Best Answer

vinod madala

• May 11th, 2007

Pulling the data from same type of sources using a same database link is called Homogenous. The key word is same databse link (thats the system DSN we use).

Answer Question  Select Best Answer

vinodh259

 Profile Answers by vinodh259 Questions by vinodh259

• May 11th, 2007

who said that we cant use joiner for homogenous sources. but the thing is performace becomes bad if we use joiner transformation after source qualifier.? it is for the fact that for any sources (homo&...

Phani

• Feb 16th, 2007

This is because performing join at database level is must faster than performing join at session level. So, if source tables r originating from the same database( say relational) prefer join in the source qualifier transformation than for opting joiner transformation.regards,Phani...

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

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

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

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

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

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

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

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

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

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

Answer Question  Select Best Answer

sivakumar

• May 2nd, 2007

It is not possible

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

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

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

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

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

As explained above informatcia server has 3 methods to recovering the sessions.Use performing recovery to load the records from where the session fails.

ggk.krishna

 Profile Answers by ggk.krishna Questions by ggk.krishna

• Apr 8th, 2007

Hi,We can restart the session using session recovery option in workflow manager and workflow monitor. Then the loading starts from 10001 th row.If you start the session normally, it starts from 1 st row.If you define target load type as "Bulk", session recovery is not possible.

Answer Question  Select Best Answer