DSXchange

Hello Vasu

Thanks for your reply.since one is production database and another is backup database they have the same metadata while comparing the same table but we have 122 tables with each pair having different metadata

Thanks

Hello, I have a requirement where i have to compare two databases one is backup database and other one is prod database. We have around 120 tables in each database schema and we have to produce delta by comparing those tables. Is there a optimal to do this. I am thinking of change capture stage. but...

Hello In oracle stage if we use Read Method=Table and Table=Tablename will be able to generate an automatic sql query so that we dont have to define the columns. Is there a way that i can get all the column names just by specifying the Tablename so that i dont have to define all the columns. Appreci...

Hello

i need to compare the two tables row by row and i need to output the difference. i need to capture what is changed between those 2 tables.

Thanks

Hello

I have a requirement where we have to compare two tables of same structure from different databases. we have to compare almost 200 tables. The tables we need to compare have the same structure but each table will be of different structure. Do we have create 200 jobs or is there a best approach?

Hello I have a problem while converting string to time stamp. Source is falt file and target is flat file and i am using transformer. In the source i am taking the string which is varchar(8) and in the format YYYYMMDD and want to populate into the target file with date format YYYY-MM-DD. I have used...

Hello, I have a clarification on lookup fileset. I have a requirement in which i need to generate a lookup file set which will be used later for the lookup. My question is how many records we can store in lookup file set. Will there be any performance issues based on number records we use to generat...

Hi eveyone, I need some help regarding appending the leading zero's infront for negative values My source file is a simple text file , which has a column QT of integer type of length 6. The input data for QT is like 888 -3456 12 -22 And i have to map column QT to QTY with leading zeros and the targe...

Hello I have a file with 10 records with each record length 600 bytes. My requirement is i need to read the file and based on constraints i need to split the records into two streams and write them into 2 MQs. The approach we adopted was to first split the records and write them into two intermediat...

Hi, I have a User defined sql in oracle oci stage which extarcts the values based on begin and end date condition E.g to_char(Begin_date,'YYYY-MM-DD')>=(#prev_month_begin_date#) and to_char(End_date,'YYYY-MM-DD')>=(#prev_month_End_date#).There are 2 routines which calculates the value define in para...

Hi all, I need some help regarding importing the .txt file to my unix server. I FTP the file from my system to unix server. Here iam using a WINSCP tool for FTP purpose. Here iam using sequential file as a source . The following are the warnings iam getting while i run the job. 1.Testdata,0: Missing...

hello i am writing a simple select query from oracle database by using oracle enterprise stage. select null as DATA from DB_SHP_DT i defined DATA as column name and i want null values in the column. I am extracting the data from database and writing it to dataset. when i tried to execute its getting...

I FOund out the Problem.The Issue was Very Simple the User Defined Query contains Repetive Column which is Causing the Error.Thanks all for Participating in this ISSUE.

Thanks for your immediate reply.Thanks a lot.

It's working fine now. This solves my problem.

i tried in the command prompt as


>= `grep -i "FOOTER_FILE" /home/user/dsstage/test/Input.txt|wc -l`

It throws an error. ksh not found.

but i tried as
> grep -i "FOOTER_FILE" /home/user/dsstage/test/Input.txt|wc -l

It results 1. without blackquote it's is working fine.