DSXchange

dsusersaj wrote:Are you talking in terms of datastage - I want to join this table and create a virtual table in IA and then run column analysis?

Yes I am talking in terms of datastage.
Btw,what is IA?.[/quote]


Sorry - I am talking in Information Analyzer
Am I in the wrong Forum ?

dsusersaj wrote:Are you talking in terms of datastage - I want to join this table and create a virtual table in IA and then run column analysis?

Yes I am talking in terms of datastage.
Btw,what is IA?.[/quote]


Sorry - I am talking in Information Analyzer
Am I in the wrong Forum ?

Are you creating your target table VIRTUALA on the go based on the lookup result?. I guess not and it already exists. So on that assumption I beleive your requirement is to join tables B and A on columnC1 which exists on both tables,and load the matched records to VIRTUALA. Is that what you are loo...

Are you creating your target table VIRTUALA on the go based on the lookup result?. I guess not and it already exists. So on that assumption I beleive your requirement is to join tables B and A on columnC1 which exists on both tables,and load the matched records to VIRTUALA. Is that what you are loo...

Are you creating your target table VIRTUALA on the go based on the lookup result?. I guess not and it already exists. So on that assumption I beleive your requirement is to join tables B and A on columnC1 which exists on both tables,and load the matched records to VIRTUALA. Is that what you are loo...

Hello Can anybody please guide me for the following I need to look up a table A and based on matched results (on a key value) i need to create a virtual table so a virtual table say "VIRTUALA" is primarily based on table 'A' but VIRTUALA table needs to contain only those values of its col...

Hello Can anybody please guide me for the following I need to look up a table A and based on matched results (on a key value) i need to create a virtual table so a virtual table say "VIRTUALA" is primarily based on table 'A' but VIRTUALA table needs to contain only those values of its col...

Hello Can anybody please guide me for the following I need to look up a table A and based on matched results (on a key value) i need to create a virtual table so a virtual table say "VIRTUALA" is primarily based on table 'A' but VIRTUALA table needs to contain only those values of its colu...

Hello Gurus I have a requirement I have multiple columns Column1 Column2 A A1 A A2 A A3 B B1 B B2 so on I was trying to get key columns for both as follows Column1 Column2 KeyforColumn1 KeyforColumn2 A A1 1 1 A A2 1 2 A A3 1 3 B B1 2 1 B B2 2 2 So on Can you please tell me how to use SKG stage to ac...

My bad , I did a search but looks like I didn t do it right,
Thank you

Hi Gurus
I am new to Quality stage , I have been going through the documentation but unable to find what "Provision all" option does, I am trying to find what exactly it means once you select a rule set .


Please share your knowlege on this (this might be a basic question)


Thank you

Ray/Creig

You are right, I had a wrong value in one of my query through which i was testing the result set

Sorry to waste your time
This works just fine

Marking it resolved

Hopefully i am understanding your question correctly I have an input.timestamp field which i am comparing with a lookup.timestamp field Both are having the same format 'YYYY-MM-DD HH24:MI:SS' both the fields are pulled up by converting into char TO_CHAR(inputtimestampfield, 'YYYY-MM-DD HH24:MI:SS'),

Missed the timestamp format
Here is what both timestamps look like
eg
YYYY-MM-DD HH:MM:SS

Hello Gurus I am trying to compare two timestamp fields in a stage variable, in.timestampfield < lkp.timestamp field ? When I do a comparisons directly by above condition i am not seeing the desired result I tried to search the forum with the key word "compare timestamp" but could nt see a...