DSXchange

Hi Guru, what about the order they are stored in the repository. what i mean is that when i access through administrator, it displays the order in which the parameters are defined, that means even the order in which they appear are user dependent. I just wanted to know is there any default order in ...

Hi Gurus, Instead of writing comments.They have dealed with some other company.They exported us jobs.I imported these jobs.Now they are saying to analyze these parameters.I said by means of prompt. PROMPT-DEFINES THESE PARAMETERS, they are saying these are user dependent.Since they are user-dependen...

Hi Gurus, These are some of the parameters declared at project level. I need to identify these parameters. when i say to my team that by observing the prompt we can analyze a parameter, they say that this is not the justified way.I mean this #$MDW_USERNAME# correspond to user name. Since i can use a...

Hi Gurus, Sorry for posting here, but iam expecting help from you Gurus. I connect the physical datamodel to oracle through ERWIN. I want to generate schema of my datamodel into oracle. I created a subject area, later on clicked on forward engineer/schema generation in tools tab of ERWIN.Later on ch...

Hi Gurus, I changed the de-limeter to . and quote character to 000. My o/p data is in this format. filename salma"deptno","dname","loc" 20 accounting boston 10 ........... ......... 15 ............ .......... when i click on tab: view data:NLS_READ_DE-LIMETED()-INVALID ...

Hi,
Sorry, since you are Gurus, i thought that you people would help me in getting the best optimized approach.

cheers;
vijay

Hi Gurus, folder stage----->transformer----->sequential file. folder stage has a text file called dept. i defined the folder stage properties (columns) as filename varchar primary key 255------------> this gives the filename record longvarchar 9999999999---->lists the contents of file. i defined the...

Hi Gurus, I mean to say ,for eg: scott is the default schema name in oracle. instead of working out with that schema, iam creating new schema by sql command create user username identified by password. grand dba priviledges. Actually my requirement is:I was given a datamodel . Now what i want is tha...

Hi,
My friend used ERWIN tool to design the datamodel.
I created schema using command

create user username identified by password.
grant dba priviledges.

Now How can i export the created datamodel into schema.
Can i do with datastage, or should i go for any other tool.

cheers;
vijay

Hi Gurus,

My friend has developed a datamodel, i have created a schema in oracle, i want to export the datamodel into my schema.Can anyone help me out.

cheers;
vijay

Hi Gurus, Iam not playing with different stages.Some times i need to use different stage beacause i never used these stages. Only this stage, there was no requirement i was trying to use this component.I want to analyze this component and use whereever necessary and i dont want to be in awkward posi...

Hi Gurus,

In that case will my design change to

odbc----->transformer--->rowsplitter.

please help me.

cheers;
vijay

Hi, I have created a table in oracle caled saa, it has columns column names: empno, fullname,salary. my design is odbc----->rowsplitter----->sequential file. i want to split the column fullname into firstname and lastname. In the row splitter, i defined the properties. column to be splitted:fullname...

Hi Gurus,
I tried by selecting using named pipes in my target sequential file stage.
It doesn't extract the data at all.
My source data is the default Dept table in Oracle database.
Please help me in analyzing the error.

cheers;
vijay

Hi Guru, Thanks very much. when i used sequential file instead of ODBC in the target stage, its working fine. source columns deptno, dname, loc. target column is merged column. In the sequential file properties. I have checked firstline is column names and Omit new line. I defined targed column name...