Srinivas Kumar Paga

 Profile Answers by Srinivas Kumar Paga Questions by Srinivas Kumar Paga

• Jan 23rd, 2007

Use Sorter Transformation and check "Distinct" option. It will remove the duplicates.

manisha.sinha

 Profile Answers by manisha.sinha Questions by manisha.sinha

• Dec 29th, 2006

In the mapping read the flat file through a Source Definition and SQ. Apply a Sorter Transformation , in the property tab , select distinct . out put will give a sorter distinct data , hence you get r...

Answer Question  Select Best Answer

Ajay Kumar Mohanty

• Jan 22nd, 2007

    We are creating a session for the task through task manager

Usha

• Nov 29th, 2006

Normalizer is used to transpose columns to rows and when you are parameterizing.  Informatica power center help is great...

Answer Question  Select Best Answer

monicageller

 Profile Answers by monicageller Questions by monicageller

• Jan 19th, 2007

Hi Kiran,Can U plz tell  me in detail how do we do that?I am a fresher in informatica...plz help.thanks.

kiran

• Dec 24th, 2006

HiUse strored procedure tranformation to load time dimention

Answer Question  Select Best Answer

lakshmi1

 Profile Answers by lakshmi1 Questions by lakshmi1

• Jan 16th, 2007

Hi,Mapplets is a group of reusable transformations. A mapplet can be called from multiple mappings.A mapping also contain reusable transformations. These transformations could be used in the same mappingRegards

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Jan 6th, 2007

mapping is not reusable. mapplet is reusable, mapplet is different set of transformation logic.reusable mapplets we can use in many mappnings

Answer Question  Select Best Answer

tryyogi

• Jan 15th, 2007

The error codes are in Hex .You have to convert it in Decimal to have the actual error code in Unix.Googling around you would find the error code-desc pairs on some pages. This error particularly is "Not a super user" ,as far as my memory doesn't fail me.

Answer Question  Select Best Answer

manjunathda

 Profile Answers by manjunathda Questions by manjunathda

• Jan 13th, 2007

 An operational data store (ODS) is a type of database often used as an interim area for a data warehouse. Unlike a data warehouse, which contains static data, the contents of the ODS are updated...

manjunathda

• Jan 13th, 2007

An operational data store (ODS) is a type of database often used as an interim area for a data warehouse. Unlike a data warehouse, which contains static data, the contents of the ODS are updated throu...

Answer Question  Select Best Answer

saibabu

 Profile Answers by saibabu Questions by saibabu

• Jan 11th, 2007

PIPELINE SPECIFIES THE FLOW OF DATA FROM SOURCE TO TARGET .PIPELINE PARTISON MEANS PARTISON THE DATA BASED ON SOME KEY VALUES AND LOAD THE DATA TO TARGET UNDER CONCURRENT MODE. WHICH INPROVES THE ...

Answer Question  Select Best Answer

saibabu

 Profile Answers by saibabu Questions by saibabu

• Jan 11th, 2007

Hisource data exists in OLTP systems of any form (flat file,relational database.,xml definitions.)u can acces the source data with any of the source qualifier transformationsw and normaliser tranaformation.

phani

• Jan 3rd, 2007

Hi,We get souce data in the form of excel files, flat files etc., By using source analyzer we can access the souce data

Answer Question  Select Best Answer

saibabu

 Profile Answers by saibabu Questions by saibabu

• Jan 11th, 2007

hi,scd means 'slowly changing dimentions'since dimention table maintains master data ,the column values occationally changed .so dimention tables are called as scd tables and the fields in the scd ta...

srinivas

• Jan 10th, 2007

Hi,HIRE ,DIMENSIONAL DATA  IS STORED. NO  AGGRIGATE CALCULATIONS SCD WE R USING 3 WAYS1.TYPE-1: IT'S MAINTAIN CURRENT DATA ONY2.TYPE-2: IT'S MAINTAIN CURRENT DATA + COMPLET HOSTROY RECO...

Answer Question  Select Best Answer

Two sources should have primary and Foreign key relation ships. Two sources should have matching data types.

Yuvaraj

• Jan 10th, 2007

Both the sources must be from same database.

Surendra

• Apr 10th, 2006

Also of you are using a lookup in your mapping and the lookup table is small then try to join that looup in Source Qualifier to improve perf.RegardsSK

Answer Question  Select Best Answer

Achut Perumbala

• Jan 9th, 2007

Even i encountered the same issue and i did to following to resolve the issue:1. First Delete the Server from Workflow manager.2. Configure the Server Again and give ur IP while configuring and resolv...

rajani

• Oct 10th, 2006

1. IF you have both Informatica server and client installed on same machine then first turnoff any anti-virus software running, turnoff internet connection.2. Check the settings in workflow server and try again.I hope it resolves your problem.

Answer Question  Select Best Answer

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Jan 9th, 2007

event based scheduling is using for row indicator file. when u dont no where is the source data that time we use shellcommand,script, batch file to send to the local directory of the informaticaserver is waiting for row indiactor file befor running the session.

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 25th, 2006

In time based scheduling, the jobs run at the specified time.  In some situations, we've to run a job based on some events like if a file arrives then only the job has to run whatever the time it is.  In such cases, event based scheduling is used.  

Answer Question  Select Best Answer

jyoti

• Jan 9th, 2007

yes we can access data from previous version of repository from latest version.regardsjyoti

Answer Question  Select Best Answer

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Jan 6th, 2007

Session failed after loading 10000 records, opb_server_recovry file loads the records, it maintains the record id, correct the error again run the session , session will take 10001 record on words

ravi guturi

• Jan 5th, 2007

Yes, we will find out discarded rows by using row indicator and coloum indicator..Row inidicator:DONTD-validO-overflowN-nullT-truncateColumn Indicator:01230-insert1-update2-delete

Answer Question  Select Best Answer

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Jan 6th, 2007

global repository in 7.1 versionnew cutom transformation,normalizer transformation added in 7.1

muzamil

• Aug 2nd, 2006

hiFew differences or the enchancements in 7.1 which i have noticed are Versioning in 7.1, Recovery, Can lookup flat filesso these are the differences. Best RegardsMuzamil

Answer Question  Select Best Answer

geetham

 Profile Answers by geetham Questions by geetham

• Jan 3rd, 2007

- To do lookup on flatfile, only static cache can be used.

priyamayee

 Profile Answers by priyamayee Questions by priyamayee

• Jun 8th, 2006

Hii, We use dynamic cache only for connected lookup. We use dynamic cache to check whether the record already exists in the target table are not. And depending on that, we insert,update or delete the ...

Answer Question  Select Best Answer

Use lookup transformation in u’r mapping to lookup data in a relational table,view,synonym. Informatica server queries the look up table based on the lookup ports in the transformation.It compares the lookup transformation port values to lookup table column values based on the look up condition.

Sridhar Tirukovela

• Jan 2nd, 2007

Lookup transformation in a mapping is used to look up data in a flat file or a relational table, view, or synonym. You can import a lookup definition from any flat file or relational database to which...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

Use a Lookup transformation in your mapping to look up data in a relational table, view, or synonym. Import a lookup definition from any relational database to which both the Informatica Client and Server can connect. You can use multiple Lookup transformations in a mapping.Cheers,Sithu

Answer Question  Select Best Answer

When i start the informatica services for loading in workflow manager, the informatica services shows running status but when i see the properties service, status has stooped. With-in sec services has stopped when i was trying to start the services for informatica, how can i overcome this problem?

vamsi

• Dec 31st, 2006

first u start the Informatica repository server service and then u start the informatica service in services.try it it may work.bye

Answer Question  Select Best Answer

vamsi Krishna.k

• Dec 29th, 2006

what sangeeta told is right, we can execute shell scripts using command task. Here I'm adding few more points.1) Shell script can be executed using presession and post session commands at sessions.2) ...

geetham

 Profile Answers by geetham Questions by geetham

• Dec 28th, 2006

 Shell Scripts are called through command tasks in a informatica workflow to do the following,   - To send a startup email after the start of workflow.   - To append date to t...

Answer Question  Select Best Answer

manisha.sinha

 Profile Answers by manisha.sinha Questions by manisha.sinha

• Dec 29th, 2006

create a procedure to load data into Time Dimension. The procedure needs to run only once to popullate all the data. For eg, the code below fills up till 2015. You can modify the code to suit the feil...

Appadu Dora P

• Apr 25th, 2006

Time Dimension will generally load manually by using PL/SQL , shell scripts, proc C etc......

Answer Question  Select Best Answer