Search Results

Search: Posts Made By: Maya_Pillai
5,203
Posted By Maya_Pillai
Linux script to check the informatica log
Hi,

We are loading 100 + oracle tables using informatica. At the end of the run, we need to verify the informatica log to confirm the rows are loaded properly to target tables.

There are so...
1,249
Posted By Maya_Pillai
Thanks Ramkrix. I will explain the...
Thanks Ramkrix.

I will explain the requirement here.

I need to split a list of files (around 120) in a folder based on pharmacy id. Each of these files...
5,163
Posted By Maya_Pillai
Thank you so much .. Its Perfect :) Maya
Thank you so much .. Its Perfect :)

Maya
1,249
Posted By Maya_Pillai
Pharmacy id file is just a text file - each line...
Pharmacy id file is just a text file - each line contains one pharmacyid

Pharmacy files are created from different tables. Each file format is different. One sample is attached.


Thanks...
8,678
Posted By Maya_Pillai
Thanks Jdash 1) what is the way of getting...
Thanks Jdash

1) what is the way of getting rowcount for 120 tables ?

Select count(*) from table1;

select count(*) from table 2;

like that if I list all 120 tables, the code won't be...
1,249
Posted By Maya_Pillai
File splitting issues
Hi,

I have to spilt around 120 files based on some id .These ids are provided by an input file here.For each of the 120 files, the script will read the list of ids from input file, grep and split...
5,163
Posted By Maya_Pillai
Creating a control file for a group of files
Hi,

We have almost 45,000 data files created by a script daily. The file names are of format-ODS.POS.<pharmacyid>.<table name>.<timestamp>.dat. There will be one data file like this for each...
8,678
Posted By Maya_Pillai
Compare the rowcount from tables of two databases
All,

I have to create a shell script to comapre the rowcount of 120 tables from two oracle databases. In fact, using informatica the data is loading from 120 source tables to 120 staging tables....
1,502
Posted By Maya_Pillai
Thank you so much. Maya
Thank you so much.

Maya
1,502
Posted By Maya_Pillai
Few doubts on Linux scripting
1) I have to create 3 scripts which create different output files. Script one creates datafiles, script2 creates control files and script3 creates flg files. The business wants the same timestamp to...
4,403
Posted By Maya_Pillai
Splitting the files via shell script
Hi all,
We have 102 flat files created by Informatica from 102 tables. These 102 files contain pharmcy details.
There are a total of 450 pharmcyids.The naming convention for the flat file is...
2,645
Posted By Maya_Pillai
This also gives error with the first file. ...
This also gives error with the first file.
ACCESS_POLICY_MANAGER
nawk: illegal statement
input record number 146, file ACCESS_POLICY_MANAGER
source line number 1
2,645
Posted By Maya_Pillai
Gives error. The file names have no extensions...
Gives error. The file names have no extensions here.

$ gawk -F"[<>]" '/Product Value/{getline;if(match($3,"GSM"))print FILENAME;nextfile}' *


gawk: not found

$ awk -F"[<>]" '/Product...
2,645
Posted By Maya_Pillai
Tried again after making sure there are no typos....
Tried again after making sure there are no typos. It did not return anything.

Not sure why.

- Also, I need to fetch all filenames which have a value contains GSM (like GSM management, GSM...
2,645
Posted By Maya_Pillai
Thanks zaxxon. I tried to execute the...
Thanks zaxxon.

I tried to execute the script you have given. But it did not echo any file where there are so many files which match this condition.Can you suggest any remedies here?
2,645
Posted By Maya_Pillai
search within the file in script
Hi all,

I have to search a particular folder which conatins around 2000 XML files.
I need to identify those files which have a value GSM under Product Value


<item name="Product Value">...
Showing results 1 to 16 of 16

 
All times are GMT -4. The time now is 05:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy