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

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

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

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

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

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

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

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