Yes.Because reusable tranformation is not contained with any maplet or maping.

Prasad

• May 22nd, 2007

Hi, you can use the mapping parameters or variables in a reusable transformation. And when you use the xformation in a mapping, during execution of the session it validates if the mapping parameter that is used in the xformation is defined with this mapping or not. If not, the session fails.

mahesh4346

 Profile Answers by mahesh4346 Questions by mahesh4346

• Feb 2nd, 2007

But when one cant use Mapping parameters and variables of one mapping in another Mapping then how can that be used in reusable transformation when Reusable transformations themselves can be used among...

Answer Question  Select Best Answer

g.nagaprasad

 Profile Answers by g.nagaprasad Questions by g.nagaprasad

• May 22nd, 2007

In lookup transformation there is a default clause ORDER BY...  but in case of Source Qualifier we have to give manually.

Answer Question  Select Best Answer

SRIRAM N

• May 17th, 2007

You can compare two mappings 1) with in one folder 2) two mappings in two differnt foldersMapping Designer --> Open folders--> MAPPING tab --> Compare then select two mappings to compare.Thats it !? Thanks it is working.

Answer Question  Select Best Answer

J.David Sukeerthi Kumar

• May 17th, 2007

There is on option called 'COMMIT INTERVAL', (By default its value is 10000 records)That means for every 10000 records? loaded ,the informatica server will issue an COMMIT command.If we specify 'SOUR...

Answer Question  Select Best Answer

ramgan_tryst

 Profile Answers by ramgan_tryst Questions by ramgan_tryst

• May 15th, 2007

Check-In and Check-Out refers to Versioning your Mapping. It is like maintaining the changes you have made. It is like using VSS or CVS. When you right-click you mapping, you have a option called Versioning if you have got that facility enabled.

Answer Question  Select Best Answer

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